[RESOLVED] cell has comma

hi!
when i compare the celle with screen
the screen has with comma
for example 2,294
but the cell looks like 2,294 but it shows 2294
how to have with comma when i compare with screen.

compare with the cells text property instead of value

I DID but it gives error unable to set of the text property in range class
Cells(x, MyCl).Text = Mytotal1

.Text is Read Only. Use it to get the actual text in the cell.
2,294 is just cell formating with the comma being the thousend separator. The actual value is 2294. You may set the Value but not the Text.

-Terry

Set the cell Value and Format