| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formatting is change after saving .csv file
I have a csv like
"abc", ="0007" after double click the csv file, the 0007 is left align and like string, but if I change the column abc to like def and then save, the =" " formatting is lost and if I open the csv file again, the ="0007" becomes 7 and is right-align, like integer. How to preserve the formatting in the csv file except save as .xls file? (that is, keep the ="0007") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re-formatting when saving as HTM file. | Excel Discussion (Misc queries) | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
| Excel should let me sort the file directory when saving a file | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Linear Mode
