The first question is how do I format a cell so that a
number entered shows in 000's. For example 12,395,470
would show as 12,395.5....

The second question is how do I get the number back to
normal in a formula to calculate averages, percent
returns etc.

Merry Xmas and Happy New Year!

Hi
what you could achieve is the display:
12,395

use a custom format such as
0,0,

The underlying values remains the same for further calculations

--
Regards
Frank Kabel
Frankfurt, Germany

tom donino wrote:
The first question is how do I format a cell so that a
number entered shows in 000's. For example 12,395,470
would show as 12,395.5....

The second question is how do I get the number back to
normal in a formula to calculate averages, percent
returns etc.

Merry Xmas and Happy New Year!

Tom

Custom Format to #,#.0, shows 12,395.5 in the cell.

That will be for appearance only.

The actual value for calculations will still be 12395470 as seen in the
formula bar.

Gord Dibben Excel MVP

On Thu, 23 Dec 2004 11:16:17 -0800, "tom donino"
wrote:

The first question is how do I format a cell so that a
number entered shows in 000's. For example 12,395,470
would show as 12,395.5....

The second question is how do I get the number back to
normal in a formula to calculate averages, percent
returns etc.

Merry Xmas and Happy New Year!