Forum Discussion
Automatic Date Format When Generating a CSV from Software
jeff-125 wrote: ``When I generate a .CSV of data from my database [....] I need to keep the dashed numbering format``
Excel writes the data to the CSV file exactly as it appears in the originating Excel file.
Open the CSV file with Notepad to confirm.
If that is your only concern -- how the data will appear to a recipient of the file -- there is no problem.
-----
Any "reformatting" occurs only when the CSV file is opened directly in Excel.
Excel interprets the CSV data exactly as if we had typed it manually into a cell that is formatted as General.
You might work around that by importing the CSV into Excel instead of opening it directly. That is, click Data > Get External Data > From Text and follow the prompts to choose how the input column should be interpreted.
But we cannot control how a(nother) recipient of the CSV file might open it.
JoeUser2004 Thank you.
I was able to do a work around as the .CSV is generated by the software I use to store my data. Reason for .CSV is so I can import it into Google Earth. The dashed numbers are a labeling method for those points.
I was able to format the data through a report that matched the .CSV in .XLSX that kept my dashed format. Then I created a text formatted column and copy and pasted to the .CSV. Not the best solution as I have many blank rows which create GPS points at 0, but it works.