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?
|