What you've done should work

Don't forget it wont change the data.
So if you click on one of the date cells it will still say 12/31/2004
But the format will display the date on screen/print as you want.

Steve

On Mon, 17 Jul 2006 23:11:02 +0100, Jack Wilson <Jack =

<Wilson@discussions.microsoft.com>> wrote:

> I have a spreadsheet that the data, the date was input in Excel 2003 a=
s
> 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 (ye=
s
> colons) format.
>