Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV formatting issue
I currently use Excel 2002 with SP3. I have a file I create in a worksheet
and have formatted a numeric field to be text so that I can maintain a 12 character string. I then "Save-As" a CSV file in order for it to be used in another application. Up until 3 weeks ago, the formatting was correct - now no matter what I do, when the "text column is converted to CSV, the column converts to a "general" format and I lose my character string of 12 digits (leading 0's). Aside from having to add " " around the string - is there some other technique I can use so that I am not manually adding all the quotes? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV formatting issue
Are you sure that you have lost the formatting is lost when you write to the
CSV? Have you tried looking at the CSV with something like Notepad after the CSV has been written? I think you'll find that the CSV has the format as you had previously displayed it in Excel. My guess is that your problem is that you have used Excel to open the CSV, and at that stage EXCEL has changed the formatting. Don't open a CSV with Excel if you want the formatting to remain unchanged. [If you do want to look at the CSV with Excel, don't use File/ Open but instead use Data/ Import External Data and specify the format of each column as text.] -- David Biddulph sueasmith31 wrote: I currently use Excel 2002 with SP3. I have a file I create in a worksheet and have formatted a numeric field to be text so that I can maintain a 12 character string. I then "Save-As" a CSV file in order for it to be used in another application. Up until 3 weeks ago, the formatting was correct - now no matter what I do, when the "text column is converted to CSV, the column converts to a "general" format and I lose my character string of 12 digits (leading 0's). Aside from having to add " " around the string - is there some other technique I can use so that I am not manually adding all the quotes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New issue with cell formatting | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue ??? | Excel Discussion (Misc queries) | |||
formatting issue? | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Worksheet Functions |