Importing from a Notepad file
I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0".
Is there a way to import without losing all these zeroes? |
Importing from a Notepad file
When youi Import or open a *.txt file the Text Wiizard will pop up and
in Step 3 under Column Data Format you can select Text. Leading zeros will be held. Gord On Thu, 8 Dec 2011 12:07:53 -0800 (PST), wrote: I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0". Is there a way to import without losing all these zeroes? |
Importing from a Notepad file
You did say a comma separated file which is most likely *.csv
Change the csv extension to txt then import or open directly in Excel. Gord On Thu, 08 Dec 2011 15:42:25 -0800, Gord Dibben wrote: When youi Import or open a *.txt file the Text Wiizard will pop up and in Step 3 under Column Data Format you can select Text. Leading zeros will be held. Gord On Thu, 8 Dec 2011 12:07:53 -0800 (PST), wrote: I want to import data from a comma separated Notepad file. When I import into Excel I find that the leading zeroes are dropped and I don't want this to happen. I have some fields that should be "000" not "0". Is there a way to import without losing all these zeroes? |
All times are GMT +1. The time now is 02:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com