There is only limited support for formatting:

[<1000000]0,K;[<1000000000]0,,\M

This changes the displayed text but does not change the actual value of the
cell, so math will still work. If all you want it the text in the cell, use
a formula like the following:

=CHOOSE(TRUNC(LOG10(A1)),A1,A1,A1/1000&"K",A1/1000&"K",A1/1000&"K",A1/1000000&"M")

This handles numbers up to 7 digits. Add more options to the CHOOSE function
for more numbers.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Need Help!" <Need wrote in message
...
I was wondering if it is possible to get excel to automatically convert
numbers from lets say 10 000 to 10k, or 10 000 000 to 10M etc.