| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I remove year from date
For example, I want to show 3/15/1974 as 3/15. I do not want someone to be
able to switch back the formatting so that they can determine the year. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove year from date
=concatenate(month(3/15/1974),"/",day(3/15/1974))
Copy, paste special, values, and there you go. Dave -- Brevity is the soul of wit. "Vicky" wrote: For example, I want to show 3/15/1974 as 3/15. I do not want someone to be able to switch back the formatting so that they can determine the year. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I remove year from date
Are you trying to hide birthdays from coworkers?
If yes, maybe you can just select the range and edit|replace what: 19* with: 2006 replace all Then just format the range as mm/dd But do this with a copy of the workbook--not the original if you ever need those years back. Vicky wrote: For example, I want to show 3/15/1974 as 3/15. I do not want someone to be able to switch back the formatting so that they can determine the year. Thanks! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List First Friday's Date of the year | Excel Discussion (Misc queries) | |||
| changing the year of a date | Excel Worksheet Functions | |||
| how can I stop Excel Advancing the year by 1 when I enter a date? | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| dHow do I put in the date without the year? | Excel Discussion (Misc queries) | |||
Linear Mode
