Excel with Concatenate does not format date correctly

T

Tony O

I am using Excel 2007. I want to use concatenate to combine employee
name with date started.
The date is not showing correctly.

A1=Jane Doe
B1=10/8/2011

C1=CONCATENATE(A1,B1)
The screen shows:
Jane Doe40824

What do I need to do differently, so it says:
Jane Doe10/8/2011
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate entries from a column into a cell by logical AND withanother column 2
Date Time Stamp formatting 5
Special converting of string date&time to date format 4
Concatenate multiple lines 2
Concatenate when pasting. 0
Median If in Excel not working 4
concatenate 2
Concatenate Text... with spaces 2

Top