Formatting 100's and 1000's
 

Is there a format for displaying numbers rounded to the nearest 10, and
numbers in the 1000s (upto 9999) to the nearest 100?

For example display 874 as 870 and display 8765 as 8 800.

I know about commas and "000" for thousands and millions (eg using ###,
"000" to format 123456 as 123 000).

But I've been unable to discover any information for doing something similar
to tens and hundreds.

cheers,
Christopher

Hi Chris

One way would be
=IF(A1<1000,FLOOR(A1,10),FLOOR(A1,100))

--
Regards
Roger Govier
"Chris Short" wrote in message
...
Is there a format for displaying numbers rounded to the nearest 10, and
numbers in the 1000s (upto 9999) to the nearest 100?

For example display 874 as 870 and display 8765 as 8 800.

I know about commas and "000" for thousands and millions (eg using ###,
"000" to format 123456 as 123 000).

But I've been unable to discover any information for doing something
similar to tens and hundreds.

cheers,
Christopher

thanks Greg, but I was after a format, not a function to redo the data.

cheers,
Christopher