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