| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save Excel to ASCII format
I need to save an Excel file, as comma delimited, and as ASCII. I've seen
several posts that address these individually but not together. Someone suggested to save as ASCII, just save as text (like csv, .txt etc.)... does this actually save as ASCII or is it still Binary? What steps do I follow, and how can I test this to make sure its ASCII? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save Excel to ASCII format
Saving as .csv, .txt and .prn will all result in an ascii file.
Try saving your workbook as .csv. Then close excel and open that .csv file in Notepad. You'll see what it looks like. Reopening the .csv file in excel isn't a good way to inspect the file--excel will make some decisions that may change the format when it imports the data. Aaron Z wrote: I need to save an Excel file, as comma delimited, and as ASCII. I've seen several posts that address these individually but not together. Someone suggested to save as ASCII, just save as text (like csv, .txt etc.)... does this actually save as ASCII or is it still Binary? What steps do I follow, and how can I test this to make sure its ASCII? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Save Excel to ASCII format
Is a csv file from Excel always ASCII? How do I know its not a binary text
file? Any way to confirm (ie looking at it in notepad etc.), and what am I looking for to know its truly ASCII? "Dave Peterson" wrote: Saving as .csv, .txt and .prn will all result in an ascii file. Try saving your workbook as .csv. Then close excel and open that .csv file in Notepad. You'll see what it looks like. Reopening the .csv file in excel isn't a good way to inspect the file--excel will make some decisions that may change the format when it imports the data. Aaron Z wrote: I need to save an Excel file, as comma delimited, and as ASCII. I've seen several posts that address these individually but not together. Someone suggested to save as ASCII, just save as text (like csv, .txt etc.)... does this actually save as ASCII or is it still Binary? What steps do I follow, and how can I test this to make sure its ASCII? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save a Word file as an ASCII format? | Excel Discussion (Misc queries) | |||
| How do I save an excel spreadsheet as a comma-delimited ASCII file | Excel Discussion (Misc queries) | |||
| Excel charts should have format templates | Charts and Charting in Excel | |||
| Default Save To directory doesn't work Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I save an Excel file in ASCII? | Excel Discussion (Misc queries) | |||
Linear Mode
