| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Custom format the cell as:
yy -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "yanu" wrote in message ... How to get only the year in the date format I.e in the table in need to display only year E.g 2005 - should be display " 05" automatically |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| Format an excel column as a date for a 5 day week for a year. | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
Threaded Mode
