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!