Function Rounding
 

Just wondering if there is a way to get '14,037,000' to 14,037 by using a
formular

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

If the 14037000 is in cell A1, then in cell B1 enter =A1/1000

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=394849

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