combining 2 cells to 1 with date

[tvonbehren]

I am combining information from two different cells to one cell using cell reference such as,(=B4&"/"&F5),B4 being a number and F5 the date.

So my question is how to get the date to show as a date value and still have the other value remain unchanged. I have tried to use formating but will not work to keep the date. An example would be

Please Login or Register  to view this content.

is it possible?

[NBVC]

Try something like:

=B4&"/"&TEXT(F5,"mm/dd/yy")

adjust the format within TEXT to your liking...

[tvonbehren]

Thank you very much. Was exactly what I needed.

[nicki442]

This works. However, my month is in "JAN" format. Can it convert it to a number "1" at the same time?

[NBVC]

Welcome to the forum

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.