Date to TEXT. NOT to sequential serial number

[Guest]

I need to convert the date in a date formatted column to text, and not the
sequential serial numbers. If I try to convert a date to text, I get the
sequential serial number, but I need to have it as a string so I can
manipuate the individual characters. So if I have 09/10/05 in A1 which was
entered as a date formatted cell, I would like to fix it as the characters:
09/10/05, rather than the sequential serial number (38605). Any thoughts
would be appreciated. Thanks

 

[Guest]

Use a help column and

=TEXT(A1,"mm/dd/yy")


copy down, copy and paste special in place and if necessary delete the
original dates


Regards,

Peo Sjoblom

 

[Guest]

Thanks, it worked great.