Rounded number format

Topic

New Reply

I need to make my piviot table totals appear in rounded thousands without changing the underlying data. So 123,456 would be formatted to show 123,000 or (123,000). If possible, correct rounding is helpful so 123,789 is 124,000 but this is not absolutely necessary. I’m looking for a custom number format that will do that. TYIA

Reply | Quote

Replies

You can use the mround formula , for eg Mround(a1,1000) eg 123485 will round to 124,000 , 123485 will round to 123000 et

Reply | Quote

Assuming you’d want numbers between -500 and 500 (exclusive) to appear as 0 rather than 0,000, you could use:

[=500]-#,##0,”,000″;#,##0,

Reply | Quote