Converting Excel Spreadsheet to ASCII

M

Marie

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

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

Marie said:
I need to convert an Excell Spreadsheet to ASCII format and add leading
Click to expand...
zeros during the conversion. How is this done?
 
Top