Regional Seeting Property

  • Thread starter Thread starter bkpatel2000
  • Start date Start date
B

bkpatel2000

Hi,
Bhavesh here
I have a Problem with control panel, regional setting,date
property problem.in my setting property year is shown is
as 1930 to 2029 as per the excel date and time it must be
1900 to 9999.can you give me idea.

thanking you

Bhavesh.Patel
 
Hi Bhavesh.,
The dates you are looking at have to do with entering
a two digit year. of 10 will be interpreted and stored as
2010; whereas, 35 will be interpreted and entered as 1935.l
 
Hi Bhavesh!

Don't change it. A lot of formulas assume the settings that you have.

If you enter dates mm/dd/yy if yy is less than 30, Excel will assume
the date is 2000 through to 2029. Otherwise it will assume it's 1930
through to 1999.

Excel requires to convert your double digit year to a four digit one
in order to convert your entry into a date serial number.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top