Hi,

Select column C dates then

Format|Cells - Custom

enter a custom format of MMDDYYYY

Mike

"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