Thanks to all for the replies. I appreciate it. -Jack

"Jack Wilson" wrote:

> I have a spreadsheet that the data, the date was input in Excel 2003 as
> mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to
> "dd:mm:yyyy"(31:12:2004)? I tried to change date
> format from "Format Cells----choose "date" or "custom" and tried different
> options, but they wouldnt change the data already in the cells. I have a
> spreadsheet that Microsoft is requesting information in dd:mm:yyyy (yes
> colons) format.
>
> Thanks
>
> Jack
>
>