ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I save an Excel file in ASCII? (https://www.excelbanter.com/excel-discussion-misc-queries/27094-how-do-i-save-excel-file-ascii.html)

Mrs Crinkle

How do I save an Excel file in ASCII?
 


Bill Martin -- (Remove NOSPAM from address)

Mrs Crinkle wrote:

Save as *.csv

Jay

How do I save an Excel file in ASCII?

One way...

To save formulas and values, use:
Tools Options View
and check "Formulas"

Then:
File Save as
and choose CSV as the "Save as type"

Many Excel features aren't preserved, but you'll get the basic values and
formulas for one worksheet.


All times are GMT +1. The time now is 10:56 AM.

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