View Single Post
 
Old 12-28-2018, 07:17 AM
ghaffy ghaffy is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2018
Posts: 2
ghaffy is on a distinguished road
Default formatting numbers: 14'342 -> 14'000 ?

Hi everyone,

when working with formulas, like { = 7123 * 2 }, I'd like to format the result in a way that it is not 14'246 but 14'000. In other words: rounded to the next thousand.
Is this possible with anything similar to \# "#'##0 ?

Thank you for your support.

BR Ghaffy
Reply With Quote