Function Rounding

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

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" <[email protected]> wrote in message
news:[email protected]...
> Just wondering if there is a way to get '14,037,000' to 14,037 by using a
> formular
>

You could also use a format, say

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

--
HTH

Bob Phillips

"Mangesh Yadav" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > Just wondering if there is a way to get '14,037,000' to 14,037 by using
a
> > formular
> >
>
>