Date Formatting in Excel Urgent

  • Thread starter Thread starter KICI
  • Start date Start date
K

KICI

Hi

I have a dates in excel that show as dd/mm/yyyy. However, when you click on
the cell it shows format mm/dd/yyyy. Can someone advise how this can be
achieved for the rest of the spreadsheet without retyping?

what is the formula used? I tried rightclicking on the cell but the format
is standard as the other cells but still not showing the diff date when
clicked on

Thanks in advance
 
hi...

select the cells which u want to change the fomat.
and... go to
Format-->Cells-->Number tab , then select "Custom" from catagory list.
Type your format in "Type" box.

The selected cells are formatted to your custom date format.

by
Narendra
 
You must log in or register to reply here.

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

Excel 2002: How to make the date format uniform ? 1
Date Formats 1
Excel 2007 displayed dates 2
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Date format changes in mail merge using Excel worksheet as data 2
Date automatically swaps 6
Date Format 2
Excel - convert dates to text but appear as a date format 6

Back
Top