How to force Excel not to do arithmetics when reading data from cell?

J

Jack

The data in cell is:
22:35

using .value property the value retrieved is: 0.732638888888889

I need to retrieve that data in original form.
How?
Jack
 
V

Vergel Adriano

You can use the Text property.


Jack said:
The data in cell is:
22:35

using .value property the value retrieved is: 0.732638888888889

I need to retrieve that data in original form.
How?
Jack
Click to expand...
 
E

Earl Kiosterud

Jack,

just for added info, what you should have gotten (and I got) with the Value property is
0.940972222222222 if the cell contains 22:35. This is a date-time value for 10:35 PM, or
22:35. The Text property gave you the date-time formatted version of the cell contents,
which is what you wanted.
 
Top