number expansion and contraction

T

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!
 
F

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
 
G

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
 
Top