When I save a text col (all the items are numeric) then save as CSV (MS-dos) it converts the items to numbers.
I have a worksheet where I use a Vlookup and IF functions, When IF functions the results are numbers, but in a text form. IN other words the result is coming from a text cell are "123456789000" in it. When I copy the worksheet to a new worksheet everything gets transferred OK. I then save the new worksheet as a csv (ms-dos) file. When I open the CSV file instead of "123456789000' I get "1.2E+11 ([FONT="]scientific notation)[/FONT]. How do get it so save and show the full number, which is really a text.
This is not a column width issue, but some kind of conversion issue.
TIA
I have a worksheet where I use a Vlookup and IF functions, When IF functions the results are numbers, but in a text form. IN other words the result is coming from a text cell are "123456789000" in it. When I copy the worksheet to a new worksheet everything gets transferred OK. I then save the new worksheet as a csv (ms-dos) file. When I open the CSV file instead of "123456789000' I get "1.2E+11 ([FONT="]scientific notation)[/FONT]. How do get it so save and show the full number, which is really a text.
This is not a column width issue, but some kind of conversion issue.
TIA