DOUG ECKERT wrote:
How would I convert the number below to a date format?

010306

It should come out looking like 01-Jan-06.

(DATE and DATEVALUE functions did not seem to work as advertised).

Something like this:

=DATE(100+RIGHT(A1,2),LEFT(A1,2),MID(A1,3,2))