Avatar of Stephen Byrom
Stephen Byrom
Flag for Ireland

asked on 

Changing date format in row one

I get emailed a workbook each week with updated figures that we have to ship to the customer.
Problem is, that the dates in row 1 have the following format '141112' etc etc. meaning 12/11/14 and so on.
Is there a formula or maybe vba code that I could use that would change the dates around to read 12/11/14 etc instead of 141112 ?
I have attached the workbook in question.
Your help as always is much appreciated.
Microsoft Excel

Avatar of undefined
Last Comment
Stephen Byrom

8/22/2022 - Mon