Thread: CSV to Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default CSV to Excel

Either change the file name to .TXT instead of .CSV, or else read the CSV in
with Data/ Import External Data (instead of File/ Open), then in either case
you can specify that the format of the relevant column is to be Text.
--
David Biddulph

FA wrote:
I want to post some data in my website in csv format. I want it to
be as easy as posible for users.

After doing this I tried to open the file again and I am having
problems with an error.

Excel is changing a number like this: 125E245 into scientific
notation. Numbers like 123A213 in the same column are maintained as
text.

How can I save my file in csv so Excel knows that alll the column is
text and not only some values?