Date format

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

Guest

I was copying some date data from other source to Excel. The orginal format
is 3/12/34, which means March 12 of 2034. But Excel automatically convert as
March 12 of 1934.

Is there any add on or vba program I can get right year in Excel?

Thanks
 
This is an operating system setting, not Excel.
In Windows, you need to Find your Regional Settings and find the date
settings. Adjust range for interpreting a two-digit year as necessary.
Example:
In Windows XP, you click Customize and then click on the Date Tab from the
Regional Settings and Language dialog.

tj
 
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

m/yy or m/yyyy date format 10
Excel date formatting 1
Dates before 1900 2
date format convert 2
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Adding Number of Workdays to a Date (Projects) 1
How can I stop Excel from formating my infromation as a Date? 2
Copying Dates 1

Back
Top