To actually "convert" to text you will need to Copy the suggested
formatted cell(s) and do a Paste-Special, Values. Then replace the old with
the new.

"HelenONeill" wrote:

I have dates set as 01/01/2000 and I need to convert to 01012000.