Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Macro to change 2 digit date to 4 digits
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Don Guillett, post: 3454522"] He gave this and it's better than my offering One way: Worksheet Function (in another column): =YEAR(DATE(1900+A1,1,1)) another way using a macro (change in place): Public Sub Convert2Or3DigitYears() Dim cell As Range For Each cell In Selection cell.Value = Year(DateSerial(1900 + cell.Value, 1, 1)) Next cell End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Macro to change 2 digit date to 4 digits
Top
