Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Format date with just month and year | Excel Discussion (Misc queries) | |||
I need date format to be set up as month/year. | New Users to Excel | |||
day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |