How can excel tell that 59 is 50 and 9 (I need to act on the

[rpwagner]

Assume a1 value is 59. I need to determine that the number is 50 and 9. Then I will do something using the 50 and then something using the 9... It will always be a two digit number (01 through 59). Thanks

 

[rpwagner]

And thanks for the interest guys(and gals?). Works great and have started writing code to use the number as broken out. Thanks once again and lets shelve this questions to the archives.... see ya