| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to keep leading zeros in my excel spreat sheet, How?
I need to keep the leading zeros in my CSV files. How can I do this?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to keep leading zeros in my excel spreat sheet, How?
One way is to put an apostrophe (single quote) in front of the value
-- Gary's Student "Mark Engbretsen" wrote: I need to keep the leading zeros in my CSV files. How can I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to keep leading zeros in my excel spreat sheet, How?
Pre-format the cells/column as TEXT
Vaya con Dios, Chuck, CABGx3 "Mark Engbretsen" wrote: I need to keep the leading zeros in my CSV files. How can I do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want to keep leading zeros in my excel spreat sheet, How?
If you can see the leading 0's in excel, then after you create your CSV file,
don't import it back into excel to verify it. Open that CSV file in Notepad--or your favorite text editor. (Reopening in excel will lose those leading 0's--but they should be there in the CSV file.) Mark Engbretsen wrote: I need to keep the leading zeros in my CSV files. How can I do this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Spliting a number with leading zeros | Excel Discussion (Misc queries) | |||
| make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
