Convert the number to a true date and then format that date...

=DATE(VALUE(LEFT(A1, 4)), VALUE(MID(A1,5,2)), VALUE(MID(A1,7,2)))
--
HTH...

Jim Thomlinson


"Alan Sexter" wrote:

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