Thousand separator

other Xcelsius - Crystal Dashboard Design
1

Hello,

I want to set thousand separators in some Xcelsius objects .
For example 60000000 should be displayed 60 000 000.

But when I set the thousand separator option it shows 60000 000.

Any idea?

Thanks!

JFCab :fr: (BOB member since 2009-01-22)

2

hi there

you can get this by using custom format in Excel spreadsheet

format cells and go to custom # ### ##0 use this format.

if you want currency format set $# ### ##0 like this.

Hope this helps

dandamudi :india: (BOB member since 2008-07-03)

3

Hi ,

In a pie charts, format in Excel do not change it in the chart.

It’s working for Excel Spreadsheet object but not for other Xcelsius objects…

Any ideas ? :?

Thanks!

JFCab :fr: (BOB member since 2009-01-22)

4

Ok I understood, In fact I have to set the format in Excel and then re allocate the object to the correct cellsÂ…

Thanks :slight_smile:

JFCab :fr: (BOB member since 2009-01-22)