Getting date to display properly when using &

[TWTHOMAS]

I have a sheet that has an event, a date, a city and a state in cells A2, B2, C2 and D2.
The formula I am using is as follows
=A2&" - "&B2&" - "&C2&", "&D2

The dates are the short date format for example 9/4/2024 and I have tried to format the date cells as text and general and short date.

Regardless of how I format them, the result appears the date changes to something like 45539 instead of 9/4/2024.

So instead of Indiana University - 9/4/2024 - Bloomington, IN, I get Indiana University - 45539 - Bloomington, IN

Any suggestions?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=A2&" - "&text(B2,"mm/dd/yyyy")&" - "&C2&", "&D2

 

[TWTHOMAS]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=A2&" - "&text(B2,"mm/dd/yyyy")&" - "&C2&", "&D2

Excel 2016 I'll update my profile also. Thanks

 

[TWTHOMAS]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=A2&" - "&text(B2,"mm/dd/yyyy")&" - "&C2&", "&D2

Also, that worked!!! Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.
Thanks also for updating your profile.