Converting Excel Spreadsheet to ASCII

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to convert an Excell Spreadsheet to ASCII format and add leading zeros during the conversion. How is this done?
 
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?
 
Back
Top