Routinely I export parameter values from a data analysis program in columns to EXCEL : the number of decimal points needed varies from parameter to parameter. I have tried a CSV file format. I find that then if I have a parameter with a value, e.g. 13.46 then after export into Excel it is 13.46. But for the same parameter if I have a value of 13.00 then in Excel it is 13. Similarly for a different parameter if it is reported as required in my data analysis program as e.g. 0.1235 then it shows 0.1235 in Excel. On he other hand if the parameter is 0.1200 in my data analysis program then in Excel it is shown as 0.12. I am wondering if this can be addressed in Excel so that the same numbers are reported in Excel as the source data analysis program.


Angus