Excel Date Format

Closed
baker5801
Posts
1
Registration date
Monday August 27, 2012
Status
Member
Last seen
August 27, 2012
- Aug 27, 2012 at 11:24 AM
 Baker5801 - Aug 28, 2012 at 06:04 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Aug 28, 2012 at 12:52 AM
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!
0