View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kei kei is offline
external usenet poster
 
Posts: 2
Default 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")