| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel default date format
1) The default date format for Excel is "21-Mar" when I enter date recognized data. This is unusable for me, I need the year displayed. How do I change the default date format to display the year. 2) With default also, Excel sometimes requires "=" in equations and sometimes not; i.e., if I enter a '-' it converts the cell to an equation. How do i stop this so that it only makes equations when I enter '='. 3) How do I get help on Excel inconsistancies like the above in Excel documentation anywhere? mjk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to manage/change the default month/day date format? | Excel Discussion (Misc queries) | |||
| How do I maintain my date format, when I copy a sheet, in excel? | Excel Discussion (Misc queries) | |||
| How do I change the default number format in excel? | Excel Worksheet Functions | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Excel Default date for date format | Excel Discussion (Misc queries) | |||
Threaded Mode
