Format for rounding to hundreds place

  • Thread starter Thread starter Tony @ Work
  • Start date Start date
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
 
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
 
Back
Top