hello
could someone help me with an excel formula to be used in attached sheet.
I need a formula that writes each of the numbers in column A to column B in a date format.
For example Value in A2 is 20150730 therefore I need to write this as 30-07-2015 i:e in date format in column B.
I have attached the sheet please help