preserve leading zeros in CSV.. how?

[muffins]

Hi everyone,

I've a csv file with

,Blankman,,SomeTown, SD, 00298

When I opened this file, the text 00298 becomes 298. How can I preserve the leading zeros?

Many many thanks!!

 

[RichardS]

When you open the file, are you using the Text Import Wizard? If so, at step 3, highlight the column with your zip code, and click the Text radio button in the top right hand section of the dialogue box.

Richard

 

[muffins]

my file is in csv format. When I open it, whether in excel or not, there's no text import wizard.

 

[Yogi Anand]

Hi muffins:

See if this helps ...

y030210h1.xls
	A	B	C	D	E
1	City	State	Zip	Zip
2	Detroit	MI	48226	48226
3	Rochester	MI	48309	48309
4	SomeTown	SD	298	00298
5				formatentries afterimporting toNumberSpecial FormatasZipCode
6
7
8
9
Sheet5

</SPAN>

 

[predominantly]

What about creating a macro to apply text formatting to selected fields
in a csv file or xls file? Is this doable?

 

[Yogi Anand]

What about creating a macro to apply text formatting to selected fields
in a csv file or xls file? Is this doable?

Hi Thomas:

Welcome to MrExcel Board!

Yup! ... for example for the illustration in my last post ... the following code will format all numeric entries to 5 digit ZipCode display ...

Range("C:C").NumberFormat="00000"

 

[Mark W.]

Change the file extension to .txt and open from within Excel. That'll invoke the Text to Columns wizard.

 

[Mark W.]

What about creating a macro to apply text formatting to selected fields
in a csv file or xls file? Is this doable?

No, formatting isn't preserved in .csv or .txt files. The best you could do is place an apostrophe in front of the value(s) (e.g., '00298).

 

[Ekim]

Muffins,

Using Excel XP

• Open a new worksheet.
• Go to the Data menu | Import from External Data | Import Data.
• Navigate to your csv file, select it and then click the Open button.
• Automatically, you should now be in the “Text Import Wizard” and the radio button for “Delimiter” should be clicked.
• Click the Next button.
• Click the checkbox for “Comma”
• Click the Next button.
• In the Data Preview screen, click the column showing “00298”, and in the same dialog box, click the check box for Text (it’s under the heading “Column Data Format”).
• Click the Finish button
• In the next dialog box, choose where you want to put the data.
• Click OK.

Your formatting will be preserved.

HTH

Mike

 

[Mark W.]

Muffins,

Using Excel XP

• Open a new worksheet.
• Go to the Data menu | Import from External Data | Import Data.
• Navigate to your csv file, select it and then click the Open button.
• Automatically, you should now be in the “Text Import Wizard” and the radio button for “Delimiter” should be clicked.
• Click the Next button.
• Click the checkbox for “Comma”
• Click the Next button.
• In the Data Preview screen, click the column showing “00298”, and in the same dialog box, click the check box for Text (it’s under the heading “Column Data Format”).
• Click the Finish button
• In the next dialog box, choose where you want to put the data.
• Click OK.

Your formatting will be preserved.

HTH

Mike

Ekim, when a .csv file is opened the red highlighted steps will not occur!