| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change birthday display from mm/dd/yyyy to HIDE the yyyy?
The column of birthdays have the year included. I want the year portion of
the (birth)date to go away. I tried to Format in the mm/dd style then Copy, Paste Special - Values... but it still maintains the year in the cell. Although it is not visible on the spreadsheet, a person could simply look at the top and see the year. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change birthday display from mm/dd/yyyy to HIDE the yyyy?
You may use this formula:
=TEXT(A1,"mm/dd") "johnp" wrote: The column of birthdays have the year included. I want the year portion of the (birth)date to go away. I tried to Format in the mm/dd style then Copy, Paste Special - Values... but it still maintains the year in the cell. Although it is not visible on the spreadsheet, a person could simply look at the top and see the year. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Date that does not change everyday. | Excel Discussion (Misc queries) | |||
| change yyyy date to yy | Excel Discussion (Misc queries) | |||
| Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et | Excel Discussion (Misc queries) | |||
| How do I change the display of a negative number to just read 0? | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
