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!