Format for rounding to hundreds place

T

Tony @ Work

Is there a format that I can enter which will
automatically format the number that I type in to the
nearest hundreds place? ie. 124 -> 100, 551-> 600, 1234->
1200
 
M

Mark Graesser

Tony,

=ROUND(A1,-2)

Good Luck,
Mark Graesser
(e-mail address removed)

----- Tony @ Work wrote: -----

Is there a format that I can enter which will
automatically format the number that I type in to the
nearest hundreds place? ie. 124 -> 100, 551-> 600, 1234->
1200
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Excel does not accept text format! 0
Round Question 3
Inconsistent formatting of section numbers 0
Round to a particular tolerance 3
Rounding value in place 2
to calculate numbers upwards to the nearest 300 and then to group 4
Divide a # into 3 #'s rounded to a whole # 9

Top