I have several situations where I would like format a number instead of rounding it with ROUND(...). But I cannot find the correct solution. If I have a four or a five digit number, I would like to round it to whole hundred.
For example 12,345.67 should be 12,300 and 1,234.56 should be 1.200. Is this possible?
Hope someone out there can help me.
Hi Henric,
A simple ROUND function will work.
Just make sure you use positive values in the num_digits argument for decimal places, and negative numbers for integers, tens, hundreds.
=ROUND(A1,-2) will do what you need.
ROUNDUP or ROUNDDOWN will also work, depending on what you want.
Catalin Bombea said
Hi Henric,A simple ROUND function will work.
Just make sure you use positive values in the num_digits argument for decimal places, and negative numbers for integers, tens, hundreds.
=ROUND(A1,-2) will do what you need.
ROUNDUP or ROUNDDOWN will also work, depending on what you want.
Hi Catalin
I know the ROUND-function which I use a lot, but in my particular case I would prefer to format my numbers instead of rounding them.
Not possible to hundreds level, only to thousands or millions:
#,###,"000"
or
#,###,,"000000"
Catalin Bombea said
Not possible to hundreds level, only to thousands or millions:#,###,"000"
or
#,###,,"000000"
Hi Catalin
It's what I also figured out. Thank you very much for your help and for the tip with formating for thousands and millions 🙂
Regards
Henric
