Change this format from 2017 to 01/01/2017

[thedeadzeds]

Hi Guys, i have a list of years below. I would like to change these to always show the 1st Jan followed by the year in UK date format ie 01/01/2017

Thanks

Year	Result
2017	01/01/2017
2019	01/01/2019
2018	01/01/2018

 

[Phuoc]

Try this

=DATE(A1,1,1)

 

[rollis13]

If you only need to 'show' that format you could use Custom Format: "01/01/"#

 

[thedeadzeds]

Great Thanks