You could also use a format, say

[999999]#,##0,\M;[999]#,##0,\T;#,##0

--
HTH

Bob Phillips

"Mangesh Yadav" wrote in message
...
You could simply divide by 1000.

And if you have intentionaaly put the single quotes, then assuming your
text
'14,037,000' lies in cell A1, then use:
=SUBSTITUTE(A1,"'","")/1000


Mangesh



"Lost" wrote in message
...
Just wondering if there is a way to get '14,037,000' to 14,037 by using
a
formular