P PCLIVE Feb 15, 2008 #2 Your request is unclear. But maybe this will help. =MID(A1,33,6)-MID(A1,27,6) Regards, Paul
G Gord Dibben Feb 15, 2008 #3 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
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
