number expansion and contraction

[tom donino]

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!

 

[Frank Kabel]

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

 

[Gord Dibben]

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