ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I convert an Excel 2003 file to ASCII format? (https://www.excelbanter.com/excel-discussion-misc-queries/126867-how-do-i-convert-excel-2003-file-ascii-format.html)

Pat

How do I convert an Excel 2003 file to ASCII format?
 
I need to convert an Excel 2003 spreadsheet to ASCII format. This does not
appear as an option when I go to "Save As". Your insight would be
appreciated.

Thanks!

Earl Kiosterud

How do I convert an Excel 2003 file to ASCII format?
 
Pat,

You need to save it as a text file. In the "Save as type" box, select one
of the CSV or TXT types. To see what's been saved, open it with Notepad.
Reopening it in Excel will cause some stuff to appear differently, as Excel
likes to apply formatting, sometimes quite inappropriately, to the data.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Pat" wrote in message
...
I need to convert an Excel 2003 spreadsheet to ASCII format. This does not
appear as an option when I go to "Save As". Your insight would be
appreciated.

Thanks!





All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com