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