Hi there!
I got a bunch of data stored in a CSV format, where some of the values are decimal values (two decimals). When I convert this into XLS something strange happens. When the first two digits (before the . and the decimals) are from 1 to 12 the XLS document doesnt display the number, it displays it as a date. I have checked that all my cells are formatted to general, and also tried to format them to scientific with 2 decimals and number with 2 decimals, none of which helps Any idea how to fix this?
(not surprisingly) the values without decimals remains as they wore in the CSV format.
Help will be greatly appreciated!
I got a bunch of data stored in a CSV format, where some of the values are decimal values (two decimals). When I convert this into XLS something strange happens. When the first two digits (before the . and the decimals) are from 1 to 12 the XLS document doesnt display the number, it displays it as a date. I have checked that all my cells are formatted to general, and also tried to format them to scientific with 2 decimals and number with 2 decimals, none of which helps Any idea how to fix this?
(not surprisingly) the values without decimals remains as they wore in the CSV format.
Help will be greatly appreciated!