Thanks. I tried that and the result is ######### all the way across the
fields no matter how much I shrink or stretch that column.

"ILoveMyCorgi" wrote:

I have data in columns A through P and in column C I have dates in the format
YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
file. Can anyone help me with this? susan