excel 2003 imported csv file, truncation after decimal point

  • Thread starter Thread starter RML
  • Start date Start date
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?
 
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.
 
Back
Top