CSV File Dropping Leading Zeros!

The Groon · May 23rd, 2002, 01:53 PM

I have an Excel spreadsheet with a couple of embedded macros, one of which writes data to a comma-separated value file on my A: drive, that I then upload into another mainframe application. The problem is one of my fields (Bank ABA #) sometimes has a leading zero. Unfortunately, the macro or maybe the CSV file always loses the leading zero and I can therefore not use that information!

Any suggestions????

HELP?!?!?!?!

wob · May 23rd, 2002, 02:08 PM

See if the CSV file has the zeros in it first - save it as a text file, then open it in excel. When going through the text to columns wizard, make sure all the columns are formated as text. This should keep any zero's in the CSV file.

If the zeros aren't there, its the file writing macro that has the problem. If they're there, it's your mainframe app.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 01:53 PM	#1
The Groon New Member Join Date: May 2002 Posts: 1	I have an Excel spreadsheet with a couple of embedded macros, one of which writes data to a comma-separated value file on my A: drive, that I then upload into another mainframe application. The problem is one of my fields (Bank ABA #) sometimes has a leading zero. Unfortunately, the macro or maybe the CSV file always loses the leading zero and I can therefore not use that information! Any suggestions???? HELP?!?!?!?!

May 23rd, 2002, 02:08 PM	#2
wob Board Regular Join Date: May 2002 Location: Milton Keynes - UK Posts: 95	See if the CSV file has the zeros in it first - save it as a text file, then open it in excel. When going through the text to columns wizard, make sure all the columns are formated as text. This should keep any zero's in the CSV file. If the zeros aren't there, its the file writing macro that has the problem. If they're there, it's your mainframe app.