| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| How do I identify the 7th digit in a 13 digit number, then establi | Excel Worksheet Functions | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
Linear Mode
