Date Formatting in Excel Urgent

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
 
N

Narendra Boga

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
 

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 1
Date format changes in mail merge using Excel worksheet as data 2
Date Formats 1
Date automatically swaps 6
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Date Formatting Error 1
Excel 2007 displayed dates 2

Top