Re: Saving xls file as a csv

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Earl Kiosterud (nothanks_at_nospam.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 16:30:35 -0400

Sparky,

Are you sure you're losing the leading zeroes? Open the saved text file
with NotePad to see what's really in it. Excel will change stuff like that
if you're using it to reopen the file.

Failing that, try the Text Write Program at www.smokeylake.com/excel. 

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"sparky71 - ExcelForums.com" <mschmidt@anbf-dot-com.no-spam.invalid> wrote
in message news:%23PtJsAfkEHA.524@TK2MSFTNGP15.phx.gbl...
> I have a csv file that we upload to our host system once a month.  The
> csv file type is all that the host system will read.  Another employee
> updates the csv file before I upload it.  There is a column for the
> maturity date of the security that is entered in the spread***.
> The format for the date field is mmddyyyy.  Excel will drop the
> leading zero from the date field if it is in for example January or
> 01.  In excel it will just show the 1 (1152004 instead of 01152004)
>
> The host system needs the leading zero to process the date correctly.
> You can change the formatting of the cells in the column to text and
> then it will display the leading zero in excel, but when you go to
> save the file it says some formatting or features are incompatible
> with this file format.  That's when we lose the leading zero's.  I
> then open up the file in notepad and add in the leading zero's
> manually.  Is there a way to automate this procedure or change it so
> I don't have to keep adding the zero's back in.  I thought about
> having the other person use notepad and update the values, but I'm a
> little leary of that.  The don't have any problems changing things
> using excel, but I'm afraid they might in notepad.  Any ideas or
> better ways of doing this?
> ---------
> Message sent via  www.excelforums.com
Quantcast