LinkBack URL
About LinkBacks
I have a report that we export from our system at work, in the report it exports the date as general text and shows as 6032025. How do I change it to an actual date that displays as 03/06/2025? Is there a formula I can use in the next column over?
How do i get todays date to show as an actual date?
I have a report that we export from our system at work, in the report it exports the date as general text and shows as 6032025. How do I change it to an actual date that displays as 03/06/2025? Is there a formula I can use in the next column over?
Excel 2016 (Windows) 64 bit
=CONCAT(MID(A1,2,2),"/",LEFT(A1,1),"/",RIGHT(A1,4))
Sheet: Sheet1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Another take:
Formula:
Please Login or Register to view this content.
For a true date:PHP Code:=DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2))
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try this
=TEXT(A1,"00-00-0000")+0
format result cell with required date format
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks