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
[email protected]

----- 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
 
Top