Data/ Text to Columns, click through to the final stage and select the
format of the input data (YMD or YDM).
Then format the resulting date as you want it.
--
David Biddulph

"Alan Sexter" wrote in message
...
This may be an easy question for you, but I'm having a tough time
answering
it for a credit analyst from Chicago. She is looking to take an 8-digit
number (20090105) and convert it to a date with the format "m/d/yyyy". It
seems that I need to convert the number to a text (character), then apply
the
date formatting. However, while I know how to convert a text to a number
(VALUE function), I don't know how to do the opposite function (converting
a
number to text). Can someone help me here? Thanks much!

Alan Sexter