Number Format Problems

Hi,

I am using custom number format as #.##

The data type of the column is float.

if the data is 0 then the output xls file generated has a dot in that cell instead of 0

Can you please help me resolve this?

Thanks in advance.

Find more posts tagged with

Comments

kallem

Using format code 0.## solves problem partially. With that Excel output produces '0,' out of value 0.

thuston

and "0.00" would always show two decimal places.

"#,##0.00" might be what you are looking for if you also want a thousands separator.