Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros when uploading a number from text file
I view and upload text files with a column of values that contain leading
zeros. I want to retain the leading zeros when I use Excel to view or store this data. Any suggestions on how to turn off, Excel's elimination of the leading zeros? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
leading zeros when uploading a number from text file
"mc01234" wrote in message
... I view and upload text files with a column of values that contain leading zeros. I want to retain the leading zeros when I use Excel to view or store this data. Any suggestions on how to turn off, Excel's elimination of the leading zeros? Format the cells as text. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros in text format | Excel Discussion (Misc queries) | |||
Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
zero supress leading zeros when chg format from text to number | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |