?
Solved

Excel - Date format mm/yy

Posted on 2003-02-21
7
Medium Priority
?
3,031 Views
Last Modified: 2009-07-29
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
0
Comment
Question by:wonda04
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 3

Accepted Solution

by:
ranjan01 earned 100 total points
ID: 7994413
hello wonda
just i am saying how u will date formatting
please go to start button and click on the setting and choose  control pannel. after open ur control pannel then  click on the regional settings. after open ur regional settings then you can find out date (there are more options there) just click on the date and see short date style and choose inthere what type of date style
you should choose mm/dd/yyyy. after choosen then you should click on the apply button then go to excel sheet and type ur date ok
i hope it will be help you more
thanks and regards
Ranjan
0
 

Expert Comment

by:furiae99
ID: 7994611
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
0
 

Author Comment

by:wonda04
ID: 8010693
ranjan01 - thank you, but I only want the formatting changed within Excel.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:wonda04
ID: 8010708
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.
0
 

Author Comment

by:wonda04
ID: 8010713
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.
0
 

Expert Comment

by:druid9855
ID: 8011426
Hi wonda04:  Try FORMAT/CELLS/CUSTOM and enter mm/yyyy.  This SHOULD work no matter what date you enter.  Good luck- Druid
0
 

Author Comment

by:wonda04
ID: 8028083
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.


0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question