Cell Format problem?

Aspose.Cells Product Family
1

Hi,

i defined the custom format “# ##0;(# ##0)” to one cell in Excel, and when i input a number lilke 2000000, il display 2 000 000, but in WebGrid, it shows 2000 000, why the seperation is not the same with Excel ?

Thanks.

2

Hi,

I tried your custom format in Excel, it shows 2000 000, the same as in GridWeb. So please check your Excel's configurations. Did you set something others with the cell?

And I think you may use this custom format instead:

"### ### ### ###;(### ### ### ###)"

Thank you.