how can I export an excel .CSV file and still maintain formatting

[Guest]

I have talked with an external programmer who uses CSV files on a regular
basis about the formatting issues with this file. Excel saves a file in .csv
format and REMOVES all formatting. This is the nature of this file type. If a
csv file needs editing, he recommends opening it in Notepad instead of Excel.
Notepad is a nightmare for non-savy users. I there a way to export an excel
..CSV file and still maintain formatting like decimal places?

I have used CSV files in the past for importing data into another program
also. After I saved the file in .csv format, I could not re-open the file in
excel and still import

 

[Milly Staples [MVP - Outlook]]

And this is Outlook related HOW??

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After furious head scratching, mzdeb asked:

| I have talked with an external programmer who uses CSV files on a
| regular basis about the formatting issues with this file. Excel saves
| a file in .csv format and REMOVES all formatting. This is the nature
| of this file type. If a csv file needs editing, he recommends opening
| it in Notepad instead of Excel. Notepad is a nightmare for non-savy
| users. I there a way to export an excel .CSV file and still maintain
| formatting like decimal places?
|
| I have used CSV files in the past for importing data into another
| program also. After I saved the file in .csv format, I could not
| re-open the file in excel and still import

 

[Guest]

This was not addressed for Outlook - This is an Excel question.

 

[Brian Tillman]

This was not addressed for Outlook - This is an Excel question.

Then why did you post it to an Outlook newsgroup?