Dates in Excel

A

arelh

New Member
Joined
Dec 14, 2004
Messages
17
I have a W/sht with dates in the format 8-Mar, my regional settings for Vista are set to English(Australia) which sets the date format for the above date as DD/MM/YYYY, but when I enter 08/03/2010 into a cell it formats as 3-Aug. Is this a fault, or am I missing something simple?
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
some thing wrong with regional setting. go to control panel and gain set it for English(austsralia). remove the formats and reformat. and see
 
Upvote 0
Thanks Venkat, I changed all computer settings to US, including excel locale settings then changed them all back to Australia and it is working correctly
 
Upvote 0
arelh said:
I have a W/sht with dates in the format 8-Mar, my regional settings for Vista are set to English(Australia) which sets the date format for the above date as DD/MM/YYYY, but when I enter 08/03/2010 into a cell it formats as 3-Aug. Is this a fault, or am I missing something simple?
Click to expand...

Another way is go to Format Cells>Custom
And in the box under Type:
Type in mm/dd/yyyy
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Solved
Default Table Date Bug?
Replies
5
Views
192
B-Man
B
C
  • Solved
Dates in Table
2
Replies
10
Views
430
Alex Blakenburg
A
S
  • Question
Inconsistent behaviour interpreting dates, variously as dd/mm or mm/dd
Replies
3
Views
372
MARK858
MARK858
J
  • Solved
Advanced Filter using a date as the criteria
Replies
5
Views
372
Alex Blakenburg
A
G
  • Solved
Counting zero billing days in Excel until current date
Replies
5
Views
655
awoohaw
awoohaw

Forum statistics

Threads
1,216,045
Messages
6,128,477
Members
449,455
Latest member
jesski

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top