On Tue, 11 Mar 2008 18:59:47 +0000, dslocum
wrote:

Is there a more efficient way to do this? Ron, when I used your
formulas I got #value and #Num errors.

If you got those errors, then the values you are seeing in A1 and B1 are not
the same as what is there.

For example, if

A1: 2008
B1: 828

Then the formula

=DATE(A1,INT(B1/100),MOD(B1/100,1)*100) will give the date of 8/28/2008 (if
properly formatted) and not an error.

We could spend a lot of time trying to figure out what is really in there.
Commonly there is a <nbsp which could be stripped off.

Or we could apply a formula to be sure we pick out the numbers only.

I would just go with what you have that works.

"Perfect is the enemy of good enough"
--ron