concatenate formula with text and date is returning wrong format

[thewiseguy]

Hi All, here is my current formula:

=CONCATENATE(B5," ",F5)

B5 = 2024-08-29
F5 = Cedarcrest

Output = 45533 Cedacrest

I need this to say "20240829-Cedarcrest"

Can anyone help with these adjustments?

 

[Asbestos_Jen]

Thank you, @Scott Huish , I forgot that part