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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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...
 
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

Converting MM/DD/YYYY into just MM/DD and Sorting 1
format cells from mm/dd/yyyy to yyyy 3
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
Converting date format 4
Problem formatting date as "dd/mm/yyyy" 2

Back
Top