I have data in a CSV and the number of digits for each number are formatted according to rules. I want 1 decimal place for some numbers and 2, for others, and none for others still. This is all written correctly to the file. When I open up the CSV in Excel a number like 19.0% only shows up as 19%, but I need there .0 there for sig figs reason. Is this a way I can tell Excel to not truncate anything?

12/17/2008 12:27:59 PM

1) just reformat the cells when in Excel

2) when you import the CSV initially, you have the option to set formats for each column

12/17/2008 12:55:08 PM

There are different number formats in the same column and over 10,000 data points. I want excel to just read the number as a string almost.

12/17/2008 1:17:53 PM

Agentlion's 2nd recommendation is what you want to do.

Set the format for each column to 'text' and it won't do bullshit like remove leading zeros or decimal places.



[Edited on December 17, 2008 at 2:28 PM. Reason : .]

12/17/2008 2:26:11 PM

Thanks, that did the trick. I appreciate it.

12/17/2008 2:48:34 PM