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