Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV to Excel
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV to Excel
Are there any other way? You see, the thing is I'm not the one that would be
downloading the file and I want it to be as easy as possible for the users. In addition the users would need to do this for 20 columns. Thank you! "David Biddulph" wrote: 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? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV to Excel
You could precede the data with an apostrophe so that it gets treated as
text. -- David Biddulph "FA" wrote in message ... Are there any other way? You see, the thing is I'm not the one that would be downloading the file and I want it to be as easy as possible for the users. In addition the users would need to do this for 20 columns. Thank you! "David Biddulph" wrote: 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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV to Excel
Ok. But then when I open the file in Excel I see the apostrophe.
Any suggestions? "David Biddulph" wrote: You could precede the data with an apostrophe so that it gets treated as text. -- David Biddulph "FA" wrote in message ... Are there any other way? You see, the thing is I'm not the one that would be downloading the file and I want it to be as easy as possible for the users. In addition the users would need to do this for 20 columns. Thank you! "David Biddulph" wrote: 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? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|