[RESOLVED] text value convert into number

[kamakshi]

Hi1
Mytotal1 shows "45"
cell value shows 45
Cells(x, MyCl).Value = Mytotal1
how do i convert text to number
itried
Cells(x, MyCl).text = Mytotal1
run time error 1004 unable to set the text property in range class

[Hack]

Try

Cells(x, MyCl).text = Val(Mytotal1)

[westconn1]

in excel, you can not set the text property of a cell, only the value or formula
the code you are using should convert the text string to a number in the cell, unless the cell is formatted as text
to explicitly, convert text to a number, depending on the usage, you can use val, cint, cdbl, ccur, or some others

what is the exact problem you are having?

[Pradeep1210]

Set the cell value and cell formatting appropriately.

[kamakshi]

Mytotal1 has screen value that is showing what everthe value in there for example "191"
as text
when i compare if cells(x,Mycl).value = Mytotal1
technically it matcehs 191 = "191"
but still it exitthe iff statment becasue the cell has val Mytotal 1has text formate
Cells(x, MyCl).text = Mytotal1

[westconn1]

i don't know what the problem is you are getting as this should work fine

Dim mytot As String
mytot = "121"   'string
Range("c3").Value = 121   'value
MsgBox Range("c3") = mytot   'true

is the value of the cell calculated by formula?
that is more likely to be an issue

[anhn]

Perhaps the cell was formatted as Text before the value is applied.
You need to reformat the cell to "General" or "Number" BEFORE setting its value.

Cells(x, MyCl).NumberFormat = "General" '-- or "#,##0" or any valid number format
Cells(x, MyCl).Value = Mytotal1

Cells(x, MyCl).Text is read-only property.

[kamakshi]

Thanks for everybody its working great.