Cell Format

S

S Kumar

I input the value of 1A , 2P.. in a cell formatted as Text
(This Cell can have any text eg "Suite 100"). When I read
this value from VBA I see a value 1.00.00 AM. Can I not
retain the Value as 1A, 2P.. I tried to change the format
to "General" still no luck..

Thanks
Kumar
 
D

Dave Peterson

see one guess to your other post.

S said:
I input the value of 1A , 2P.. in a cell formatted as Text
(This Cell can have any text eg "Suite 100"). When I read
this value from VBA I see a value 1.00.00 AM. Can I not
retain the Value as 1A, 2P.. I tried to change the format
to "General" still no luck..

Thanks
Kumar
Click to expand...
 
Top