Rounding whole numbers

[Bob]

I have an existing excel worksheet with several numbers, subtotals, etc that
are all stated in whole numbers such as $1,245,789.

I would like to state all the cells in 1,000's.

For example, the number in my example above would become $1,245.

What is the easy way to do this?

 

[Wigi]

With the value in cell A1:

=ROUNDDOWN(A1,-3)

 

[BobT]

If you simply want it to display the values in thousands (not actually round
the underlying values):

1. Select all the values you want to format.
2. From the FORMAT menu, choose CELLS.
3. On the NUMBER tab, choose CUSTOM in the Category list.
4. In the TYPE box, enter #,### (or 0,000)
5. Click on the OK button.

Now all the cells will display as thousands, but keep their true values:

A1 = 1,234,567

Cell A1 will display 1,234 but still keeps its full value.

 

[Bob]

Bob Thanks for the suggestion but it does not work for me.

I am using Excel 2007.

I go the worksheet and highlight all the cells that I wish to change.

On the Home memu I find Cells and click on format cells

On the number tac under custom I have inserted #,### and have cliked the OK,

But the number does not change!

Suggestions?

 

[Peo Sjoblom]

Your numbers are text. Copy an empty cell, select the "numbers" and do
edit>paste special and select add
then try the custom format

--


Regards,


Peo Sjoblom

 

[Fred Smith]

Bob forgot the trailing comma which is needed to display only thousands. Use
a format of:

#,##0,

Regards,
Fred.

 

[T. Valko]

whole numbers such as $1,245,789.

I would like to state all the cells in 1,000's.
the number in my example above would become $1,245.

Note that using #,##0, will round the last digit:

$1,245,789 displays as $1,246