View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default printing time literally

Hi Bart;

You could try converting the values in the time based
cells to strings. Then when you print them to a text file
they will not show up as numbers.

Thanks,

Greg
-----Original Message-----
Hi

I'm printing data from an excel sheet to a text file, and

some of
these cells contain Time's. However, printing the cell

results in a number
between 0 and 1 rather than the exact string, eg "12:30"

or "4:00". How can
I print it like that anyway?

Thanks
Bart



.