| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
F2 shortcut and strange formatting of date fields
This maybe an easy question but I am stumped.
If I click in a cell and hit F2 and enter then the formatting of my date field is amended somehow. How can I apply the F2 + enter to a large number of cells all at the same time? For some date fields in my spreadsheet when changed to general format, become a number, others remain as dates - why is this and how do I get them all to be the same format (other than the F2 method I have discovered) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange phenomenon with General vs. Text formatting | Excel Discussion (Misc queries) | |||
| Shortcut key strange behaviour | Excel Worksheet Functions | |||
| Shortcut key strange behaviour | Excel Worksheet Functions | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Formatting date fields after export | Excel Discussion (Misc queries) | |||
Threaded Mode
