| 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 | |||
Hybrid Mode
