Previous Topic Next Topic

Excel Date Format

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

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
28 Aug 2012 à 00:52
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))
Baker5801
28 Aug 2012 à 06:04
Thank you!