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

any way to do this.

The 38 Digit # is in one cell.

Thanks!

Bill

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

Your request is unclear.

But maybe this will help.

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

Regards,
Paul

--

"Joe Twelve Pack" <Joe Twelve wrote in
message ...
any way to do this.

The 38 Digit # is in one cell.

Thanks!

Bill

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

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
wrote:

any way to do this.

The 38 Digit # is in one cell.

Thanks!

Bill