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
zeros during the conversion. How is this done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top