| 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) | |||
Linear Mode
