Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open a csv file and not have leading zeros eliminated
I have a File that I down Load from another system (AS400) which I converted
to CSV Format. Some of the Alphanumeric fields (cells) have legimitate values that start with 0 (zeros). When I open the file in EXCEL it strips the leading zeros from those fields. How do I prevent that.? I tried using " as a delimiter but it did not work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open a csv file and not have leading zeros eliminated
Try this:
Change the file extention to .TXT (from .CSV) When you open the file, the Text Import Wizard will engage. On Step_3, select your column and set it for TEXT That will prevent Excel from changing it to numeric values. Does that help? *********** Regards, Ron XL2002, WinXP "AS400_EXCEL_John_B" wrote: I have a File that I down Load from another system (AS400) which I converted to CSV Format. Some of the Alphanumeric fields (cells) have legimitate values that start with 0 (zeros). When I open the file in EXCEL it strips the leading zeros from those fields. How do I prevent that.? I tried using " as a delimiter but it did not work. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I open a csv file and not have leading zeros eliminated
Change the extension of your data file from .CSV to .TXT
This will cause the Text Import wizard to launch. On step 2 of the wizard, check Comma for the delimiter. On step 3, select the field with the leading zeros, then click Text. When you finish importing the data, that field will still have the leading zeros. Hope this helps, Hutch "AS400_EXCEL_John_B" wrote: I have a File that I down Load from another system (AS400) which I converted to CSV Format. Some of the Alphanumeric fields (cells) have legimitate values that start with 0 (zeros). When I open the file in EXCEL it strips the leading zeros from those fields. How do I prevent that.? I tried using " as a delimiter but it did not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|