Just thought I would pass on this tip. After using Excel for over a decade, I've never found a way to round numbers visually, without using formulas or using vba to reformat all of the data and maintaining the precision of the number (perhaps I'm just slow).

Althought a little clunky, this seems to work well if you want to round a large number of cells to the same number of digits while maintaining the underlying precision of the numbers. It requires using a custom number format and using the comma character, which when used correctly divides by 1000.

For example, let's say you want a bunch of numbers in the millions to appear rounded to the nearest thousand. Format all of the underlying cells with the following custom numberformat #,###,",000" exactly as is, including the quotes.

The #,### by itself simply instructs Excel to us commas to seperate each set of three digits. The next "," divides the number by one thousand and the last ",000" adds ,000 as a text string on the end.

If you wanted to the nearest million with a leading dollar sign, simply use $#,###,,",000,000" which includes 2 commas to divide by a million and then adds 6 zeros as a text string.

And if you don't use commas, you could round 12691 to 13000 by using 0,"000" as the customer number format.

I couldn't find this tip anywhere on the net so I thought I would add it here. I hope it helps! I know I will be using it quite a bit...

Nathan