Date format in Excel 2007 mm/dd/yy not appearing correctly

R

RickGCR

Cannot find a way to format date in a cell. I've selected Custom and
mm/dd/yy. In office 2003 Excel I could type in Jan5 and it would appear as
01/05/09, the 2007 version will not convert, Jan5 comes up as 01/01/05. I've
tried to change numerous times in every option I can find and nothing works.
Is this a VIsta problem?
 
F

Fred Smith

When I enter Jan5 in XL2007, it gives me Jan 5, 2009.

I'd check your custom format. Maybe you entered mm/mm/dd instead of mm/dd/yy

Regards,
Fred.
 
S

Shane Devenshire

Hi,

I have to second Fred's results, no problem on my machine. since you don't
need a custom format click the quick launch button at the bottom right of the
Number group
pick the Number tab and Date. Pick the 4th or 5th choice on the right side.
(Make sure that the Locale setting is English (United States)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting dd/mm/yy to mm/dd/yyyy 3
can I change the date format as dd-mm-yy 7
Change date format in Excel footer 2
Return mm/dd/yy based on 1st Day of Month 5
Text Box date format dd/mm/yy not mm/dd/yy 3
How to enter a date in DD-MM-YYYY format 2
Month (MMM) from date (dd/mmm/yy) 1
Stop Excel Changing Format 3

Top