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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to change date accepting format to day-month-year (https://www.excelbanter.com/excel-discussion-misc-queries/263904-how-change-date-accepting-format-day-month-year.html)

masc

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

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

trip_to_tokyo[_3_]

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

On May 17, 10:21*am, masc wrote:
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

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.

Gord Dibben

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

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

Gord Dibben MS Excel MVP

On Mon, 17 May 2010 01:21:01 -0700, masc
wrote:

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

All times are GMT +1. The time now is 02:10 PM.