Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
48
Views
Topic starter
Hello all. I have thousands of records with a date on each. The date looks like 25/10/2015 and i am trying to convert them all at once to look like 251015. Help please..
Posted : 11/07/2019 7:21 am
Hi Justin
Try =TEXT(A1,"ddmmyy")
Sunny
Posted : 11/07/2019 10:52 am
Hello Justin,
Have you checked out this blog article about date formatting?
Posted : 11/07/2019 3:08 pm
