how do I change date from mm/dd/yyyy to dd:mm:yyyy format in Excel

G

Guest

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
 
D

Dave Peterson

How about a custom format of:

dd\:mm\:yyyy



Jack said:
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
Click to expand...
 
S

SteveW

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format cells from mm/dd/yyyy to yyyy 3
Converting MM/DD/YYYY into just MM/DD and Sorting 1
Change format to mm dd yyyy hh mm ss 1
Forcing a date entry format of dd/mm/yyyy 1
How to enter a date in DD-MM-YYYY format 2
Format Date "dd/mm/yyyy" 1
Change MM/DD/YYYY to MM/DD/YY 5
Converting date format 4

Top