If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Default date format for a new worksheet
When I type a date "03/25" Excel formats it "25-Mar". This is a custom format
not even in the Date category. if I type "03/25/09" it formats it just like I typed it. Where does Excel get the Custom format for a new worksheet and how can I change it. |
#2
|
|||
|
|||
Default date format for a new worksheet
In EXCEL 2007 (and I believe in previous versions) you will have to take the
following actions to change the date format in a cell(s):- - highlight the cell(s) that you wish to format - right click and select Format Cells - Number tab - Date on the left hand side / select the format you want and hit OK. If my comments have helped please hit Yes. Thanks. "Kruppy" wrote: When I type a date "03/25" Excel formats it "25-Mar". This is a custom format not even in the Date category. if I type "03/25/09" it formats it just like I typed it. Where does Excel get the Custom format for a new worksheet and how can I change it. |
Thread Tools | |
Display Modes | |
|
|