MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pulling a date out of a number

Posted by Dano on February 22, 2001 5:57 AM

I use the above number as a repair number. The first 5 numbers is the store identifier "05013" the next 5 is the date the repair was issued "02151" stands for Feb 15th, 2001. I would like to put this number in another cell as a valid date. Any help would be much appreciated!

Posted by xxx on February 22, 2001 7:34 AM

Assuming your repair number is in cell A1: