Data Text to columns Next Next select Date MDY Finish out

custom format any style you like


"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).