Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date format
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 |
#2
|
|||
|
|||
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 "Chris" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
Problem with Date format from VBA code | Excel Discussion (Misc queries) |