Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Num(FieldName/1000,'0,000')
Format the number using the "Number" Tab in properties of the sheet object (Chart, Table, List etc.)
Hi
Try
NUM(FieldName,'#,##0')
Mark
Only expressions show in that tab. This is a dimension.