How to manage/change the default month/day date format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I type 7/30 in a cell (signifying the date July 30th) and I move to
the next cell it automatically changes it to 30-Jul .. which is annoying.
How can I get Excel to not auto-reformat that? Thanks.
 
By preceding the 7/30 with a single quote (an apostrophe) as in '7/30 (the
quote will no display or print)
By formatting the cells as Text BEFORE entering data
best wishes
 
Hi Chuckie-

Your issue is with Windows, not with Excel. Excel defaults to the Date &
Time format the OS is set for. Change your Windows Settings accordingly.

HTH |:>)
 
You must log in or register to reply here.

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

Trailing 30 days sum calculation with excel 1
Julian day numbers 1
Change Default Auto-Fill-In month 4
Using Dates with the IF function 2
Conditional formatting in Excel 2010 2
How do a set the current date to change in cell everyday 1
Excel Message box with days of month & date. 1
cell formatted as date won't change 3

Back
Top