wonda04
asked on
Excel - Date format mm/yy
1. type in 12/15/2003 in a cell
2. Go to Format / Cells
Is there a Date format or a Custom format that you could put in to get 12/15/2003 to look like 12/2003?
Thank you in advance
2. Go to Format / Cells
Is there a Date format or a Custom format that you could put in to get 12/15/2003 to look like 12/2003?
Thank you in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ranjan01 - thank you, but I only want the formatting changed within Excel.
ASKER
furiae99 - thank you. However, this is exactly my problem. When I do follow you steps, it stays at 12/15/2003. However, if I change the date to 12/01/2003, it formats correctly.
ASKER
furiae99 - thank you. However, this is exactly my problem. When I do follow you steps, it stays at 12/15/2003. However, if I change the date to 12/01/2003, it formats correctly.
Hi wonda04: Try FORMAT/CELLS/CUSTOM and enter mm/yyyy. This SHOULD work no matter what date you enter. Good luck- Druid
ASKER
From all your suggestions, I believe I have found the root of the problem.
- My Regional Options / Short date is set to dd/mm/yyyy.
- Typed in 12/15/2003 in Excel.
- Formatted the cell to mm/yyyy.
Excel is mapping the mm/yyyy to the 15th month / 2003 which is invalid so it keeps the formatting as a general type.
- My Regional Options / Short date is set to dd/mm/yyyy.
- Typed in 12/15/2003 in Excel.
- Formatted the cell to mm/yyyy.
Excel is mapping the mm/yyyy to the 15th month / 2003 which is invalid so it keeps the formatting as a general type.
In the cell, type 12/15/2003.
Right click and choose 'Format Cells'.
Choose the category 'custom'
In the 'type' box, enter the following: m/yyyy
Click ok. Your cell should display 12/2003
Jennifer