|
-
Mar 2nd, 2010, 02:41 PM
#1
Thread Starter
Addicted Member
 [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.
-
Mar 2nd, 2010, 02:59 PM
#2
Re: cell has comma
compare with the cells text property instead of value
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed 
pete
-
Mar 2nd, 2010, 03:49 PM
#3
Thread Starter
Addicted Member
Re: cell has comma
I DID but it gives error unable to set of the text property in range class
Cells(x, MyCl).Text = Mytotal1
-
Mar 2nd, 2010, 04:38 PM
#4
Member
Re: cell has comma
.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
-
Mar 2nd, 2010, 04:54 PM
#5
Re: cell has comma
Set the cell Value and Format
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
icon on the left of the post. 
