how to change date accepting format to day-month-year

  • Thread starter Thread starter masc
  • Start date Start date
M

masc

I would like to enter date in day-month-year in an excel sheet and it should
accept accordingly. can anyone please tell me if you know. thanks in advance
 
I would like to enter date in  day-month-year in an excel sheet and it should
accept accordingly. can anyone please tell me if you know. thanks in advance
Click to expand...

EXCEL 2007

Home / Font group / click on arrow in lower right hand corner / Format
Cells should launch / Number tab / Custom / dd-mmm-yyy / OK

If my comments have helped please hit Yes.

Thanks.
 
I would change my Windows Regional Short date settings to dd-mm-yy


Gord Dibben MS Excel MVP
 
Back
Top