Excel Date Format [Closed]

Report
Posts
1
Registration date
Monday August 27, 2012
Status
Member
Last seen
August 27, 2012
-
 Baker5801 -
Hello,



I receive a report that has the date displayed as just numbers. Example: 20120131

How can I change the data to read: 01/31/2012

Thanks!

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
suppose the number 20120131 is in E12 use this formula
change the cell address according to you

=DATE(LEFT(E12,4),MID(E12,5,2),RIGHT(E12,2))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!