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?
--
Bob G.

With the value in cell A1:

=ROUNDDOWN(A1,-3)

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Bob" wrote:

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?
--
Bob G.

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" wrote:

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?
--
Bob G.

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?
--
Bob G.


"Bob" wrote:

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?
--
Bob G.

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

--


Regards,


Peo Sjoblom

"Bob" wrote in message
...
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?
--
Bob G.


"Bob" wrote:

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?
--
Bob G.

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

#,##0,

Regards,
Fred.

"Bob" wrote in message
...
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?
--
Bob G.


"Bob" wrote:

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?
--
Bob G.

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


--
Biff
Microsoft Excel MVP


"Fred Smith" wrote in message
...
Bob forgot the trailing comma which is needed to display only thousands.
Use a format of:

#,##0,

Regards,
Fred.

"Bob" wrote in message
...
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?
--
Bob G.


"Bob" wrote:

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?
--
Bob G.