excel 2003 imported csv file, truncation after decimal point

R

RML

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?
 
S

Shane Devenshire

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.
 
D

David Biddulph

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel And Notepad 3
Date shows "00:00.0" rather than actual value 6
Excel does not accept text format! 0
Number in text format in CSV file 3
Import Multiple CSV Files from Same Folder into Open Workbook 5
CSV->Excel Data Problem 1
How to save files in the formats of *.csv(MS-DOS) in Excel 2003 2
Cannot import CSV file into ACCESS 1

Top