Keeping the format of a date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning

I have a worksheet with data in column A, column B and a date in column C.

In column D, I have to enter a formula which will automatically enter all
the information from the cells in A, B and C into one cell. For instance, A1
could contain Fred, B1 could contain Jones and C1 could contain 09/10/06.
Therefore, in cell D1 I need it to say 'Fred Jones 09/10/06'.

I can create the formula and it does work, however, it doesn't keep the
formatting of the date from column C and simply converts it into a number so
it doesn't make sense when entered into D1.

Is there any way I can ask Excel to keep the format of the date??

Thank you.

Louise
 
=A1&" "&B1&" "&TEXT(C1,"mm/dd/yy")

Regards,
Stefi

„Louise†ezt írta:
 
Don't worry, I also didn't think of that when I was a newbie! Thanks for the
feedback!

Stefi


„Louise†ezt írta:
 
You must log in or register to reply here.

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

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
countifs Function not giving desired result with date criteria 2
Concantenate which keeps bold of some parts. 5
Count entries in the column translating to minutes. 5
Lookup Array Calendar 4
conditional format 20
How can one set a value TO another cell? 5
Matching dates to cells 8

Back
Top