Jul 26, 2006 · 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. …

Mar 6, 2025 · Re: Change decimal seperator when importing a csv file I don't why this is so difficult in Power Query. Can you allow use of the legacy text import wizard? The old text …

Jun 28, 2012 · Re: .csv file shortens numbers with "E+" if the numbers are longer than 15 digits, Use Data|Text to columns to format the columns as text (3rd window in text to columns wizard).

Dec 25, 2023 · Re: Overcoming date formatting changes in csv file I'm not sure I understand exactly where in your process these text strings are being converted to dates. If I open your …

Apr 22, 2024 · A csv file, since it is just a text file, has no way to save number formatting information. When you open a text file with date information (assuming Excel recognizes the …

Feb 3, 2015 · Losing decimal places in .csv file saved in Excel Good afternoon I have been downloading a CSV file of simple financial data for over two years. I edit the file in Microsoft …

Jan 21, 2016 · Saving as CSV with double quotes Hi everyone! I'm trying to save an Excel file as CSV so that the end result would have double quotes " " around each data. I've tried by adding …

Mar 20, 2016 · Re: Why does the number format change when I save the file a CSV file I think that it has to do with the width of the columns of Excel when you open the file. The width is too …

Dec 31, 2014 · Re: Question marks appearing when I convert excel spreadsheet to txt file This sounds like a font/language problem where some characters in the font that the document was …

Oct 21, 2016 · Re: .CSV to .XLSX Automatic Batch Conversion So using the Macro Recorder and thus opening manually from Excel a csv file and save it as a workbook will give you a base …