Combine 3 Different Numbered Cells In Row To Create One Number

I am pulling data from an Aussie weather website that has Julian Dates. In order for me to utilize those dates, I have to convert them to yyyy, mm, dd. Please look at my example below and appreciate the help!

Try

E2

Formula:

Please Login or Register  to view this content.

Try
=A2&TEXT(C2,"00")&TEXT(D2,"00")
or
=TEXT(DATE(A2,C2,D2),"YYYY,MM,DD")

Or
=DATE(A2,C2,D2)

And Custom format yyyy, mm, dd

Or another way
=DATE(A2,1,1)+B2-1

Do the same Custom format.