| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Point Vertical Alignment in Excel 2003 | New Users to Excel | |||
| Decimal point will not hold 2 places in Excel 2003 | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| Decimal Point Excel 2003 | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
Linear Mode
