Link to home
Start Free TrialLog in
Avatar of wonda04
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
ASKER CERTIFIED SOLUTION
Avatar of ranjan01
ranjan01

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of furiae99
furiae99

Hello Wonda04

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
Avatar of wonda04

ASKER

ranjan01 - thank you, but I only want the formatting changed within Excel.
Avatar of wonda04

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.
Avatar of wonda04

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
Avatar of wonda04

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.