Converting Excel Spreadsheet to ASCII

[Guest]

I need to convert an Excell Spreadsheet to ASCII format and add leading zeros during the conversion. How is this done?

 

[Nikos Yannacopoulos]

Marie,

You're in the wrong newsgroup! This is Access, there are other newsgroups
for Excel.

Howerver:
If you don't want to use VB code (I assume you don't), first format the
numbers as you want them, e.g. Format > Custom, Type 0000 to display 3 as
0003, 105 as 0105 etc. Then File > Save As, file type Unicode Text (*.txt).

HTH,
Nikos

I need to convert an Excell Spreadsheet to ASCII format and add leading

zeros during the conversion. How is this done?