Number Formatting of Dimensions

[greend21]

Hi,

I have a dimention that is currently showing numbers such as 388130 but I want this to display as 388,130. I tried using

Num(FieldName,'##,###') but it isn't working. Could you let me know what I am doing wrong?

Thanks,

Dan

[antoniotiman]

Try this

Num(FieldName/1000,'0,000')

[Anonymous]

Format the number using the "Number" Tab in properties of the sheet object (Chart, Table, List etc.)

[Mark_Little · Accepted solution]

Hi

Try

NUM(FieldName,'#,##0')

Mark

[greend21]

Only expressions show in that tab. This is a dimension.