View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?