I want to truncate/crop 3854502.2 into 545 in Excel. How do I do.
 

I am trying to take a long UTM grid and truncate it into its standard form.
To do so, I must take the first two digits off the left and want to take the
decimal and the last two digits off the right. I believe I have done this
before but can't remember how. Thanks.

Have a look in HELP index for MID

--
Don Guillett
SalesAid Software

"billybob" wrote in message
...
I am trying to take a long UTM grid and truncate it into its standard
form.
To do so, I must take the first two digits off the left and want to take
the
decimal and the last two digits off the right. I believe I have done this
before but can't remember how. Thanks.

Or maybe something like:

=MOD(INT(A1/100),1000)

if it's always the same format (0000000.0)

billybob wrote:

I am trying to take a long UTM grid and truncate it into its standard form.
To do so, I must take the first two digits off the left and want to take the
decimal and the last two digits off the right. I believe I have done this
before but can't remember how. Thanks.

--

Dave Peterson