Converting a number to a text (character)
 

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

Converting a number to a text (character)
 

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

Converting a number to a text (character)
 

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