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?
 
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
Solution
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

A
  • Question Question
Date calculation formula
Replies
5
Views
211
Tetra201
Tetra201
D
  • Solved
If this cell = this date and that cell = this date then enter data form this cell
Replies
5
Views
143
davids4500
D
E
  • Solved
Formatting date issue
Replies
3
Views
320
zero269
Z
H
  • Solved
VBA and date formatting
Replies
8
Views
386
Joe4
Joe4
Z
  • Question Question
VBA: Date Format Issues with Data Validation
Replies
3
Views
415
zero269
Z

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