I have a 38 digit # and I want to subtract 27 thru 32 from 33 thru

P

PCLIVE

Your request is unclear.

But maybe this will help.

=MID(A1,33,6)-MID(A1,27,6)

Regards,
Paul
 
G

Gord Dibben

In Excel there is no such thing as a 38 digit number.

Excel will recognize a number up to 15 digits then returns zeros after that.

Part of your subject line is cut off.

Re-post with a full description in the body of the post.


Gord Dibben MS Excel MVP

On Fri, 15 Feb 2008 13:25:01 -0800, Joe Twelve Pack <Joe Twelve
 

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

Copy addition formula of non-consecutive horizontal cells 2
Rate of change 4
Need help with range value calculation 5
Complicated Formula Problem 10
Counting question 1
Top 25 List of Times 1
get a list of sequence number that meet 3 criteria 0
find and replace numeric strings in larger text strings 8

Top