Laura,

I can't see your original post (it just ain't there -- just your reply to Nick's reply), and
you haven't quoted the replies, but I'll add this. Saving as CSV writes a text file exactly
as it appears (as formatted) on the sheet. If you open that saved text file with Notepad,
you'll see exactly what's in the file, character for character. There is no formatting
information in a text file -- just characters, and Notepad shows you what they are. Thats's
all. If you reopen the text file in Excel, formatting gets applied that isn't always
desired (leading zeroes dropped, stuff that looks like a date but ain't a date gets
converted to a date, etc.). In short, it's probably getting saved as is, but if reopened in
Excel, it's getting changed.

If saving it as a CSV truly isn't doing what you need, try the Text Write Program (and Excel
Workbook with a macro) at www.smokeylake.com/excel.
--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"laura1027 via OfficeKB.com" <u34668@uwe wrote in message news:73434a09ef0e7@uwe...
Nick, text formatting the colums do not work. The ending zeros still
disappear when converting the excel file to CSV format.


Dave, saving the file to notepad works in so far as the ending zeros do not
disappear and remain when converting to notepad. However, I have to find out
if the notepad format is the correct format for downloading into the DOS
program. I do not do this part, my current employer, who created the order
entry DOS program that he uses for his business, does the downloading. I
will see if it works tomorrow.

Thank-You both for your help.

Laura

--
Message posted via http://www.officekb.com