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

B

billybob

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.
 
D

Dave Peterson

Or maybe something like:

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

if it's always the same format (0000000.0)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Truncating Number Series 3
Truncating a VIN 3
Formatting time in Excel 2007 3
How to truncate digits? 6
How do I truncate decimal places on a merged field? 1
How to modify and updte specific styles for specific paragraphs across the document 0
truncate 1
I want to enter a figure &excel makes last two digits decimals 4

Top