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