CODEWITHSUNDEEP
excelvbadateformat
Ashok Gupta
Ashok Gupta

Reputation: 2297

Why is the Date format changing?

I have an Excel spreadsheet where there is a date column, and the date is entered in the format of dd/mm/yyyy.

When I open this file in My Excel, the Date column converts to date, but in the format of mm/dd/yyyy automatically.

i.e., 12/03/2009 4:44:44 (12March) but it takes it as 3rd Dec 09..

Would you please shed some light on the matter.

Upvotes: 0

Views: 658

Answers (3)

Senseful
Senseful

Reputation: 91911

Just because the date appears in a certain format doesn't mean it will accept that format as input as well.

I believe the format accepted for input depends on your regional settings in Windows. (Start > Control Panel > Regional and Language Options)

If you just want to show the same format as was inputted, you need to change the cell's format options. (Right-click the cell and choose Format)

Upvotes: 4

pdemarest
pdemarest

Reputation: 1830

Try Changing the cell formatting.

Format Cells -> Number -> Date

You might have to change the locale from English(US) to the appropriate localization.

Upvotes: 1

jgallant
jgallant

Reputation: 11273

You need to set the formatting of the cell to ensure that the format is displayed properly.

Right-click on the cell, Format Cell.

Select Date

Choose the proper format

Upvotes: 2

Related Questions