excel 2003 imported csv file, truncation after decimal point
 

I import a csv file into excel 2003. this number 0:00:00.0068 is now this
00:00.0
in the spreadsheet. How can I correct to get the full number?

excel 2003 imported csv file, truncation after decimal point
 

Hi,

I don't have a file with this type of data but first question is - is that
the display or what is shown on the formula bar?

Suggestion, on the last step of the Import Wizard select the field in the
preview pane and click the Text option.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"RML" wrote:

I import a csv file into excel 2003. this number 0:00:00.0068 is now this
00:00.0
in the spreadsheet. How can I correct to get the full number?

excel 2003 imported csv file, truncation after decimal point
 

The best you'll do an an Excel time is 3 decimal places so formatted as
h:mm:ss.000 that's 0:00:00.007

If you want 0:00:00.0068 you'll have to read the data in as text (use Data/
Import External Data).
--
David Biddulph

RML wrote:
I import a csv file into excel 2003. this number 0:00:00.0068 is now
this 00:00.0
in the spreadsheet. How can I correct to get the full number?