Active Member
June 26, 2016
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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.
Active Member
June 26, 2016
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
1 Guest(s)