Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change date default settings
Select the area where you want to enter these dates, right click, select
format cells, change to Custom, and in the right hand window, where it says Type: block the default setting and type in dd- MMM and OK out. If you now enter a date as 22/9, it will show as 22- Sep "bentendo" wrote: hi i need to create a list in excel using the date format 21- Sep. everytime i do this it automatically formats this as 09/21/2006 how do i change this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Change Date without Opening the Workbook | Excel Worksheet Functions | |||
How do you change the excel number default settings? | Excel Discussion (Misc queries) | |||
Excel default date format | Excel Discussion (Misc queries) | |||
How do I change the default settings in charts? | Charts and Charting in Excel |