Date format not appearing in concatenate

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

Guest

How to get the actual date format while concatenate formala is applied. I am
getting value of date instead of DATE. Pl. help me
 
Post your formula. Also, what is the format of the source cell? mm/dd/yy,
yyyy-mm-dd, etc.

Biff
 
You'll need something like =A1&TEXT(B1,"dd/mm/yyyy")
Adjust the format spec in the TEXT function to suit.
 
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

concatenate 5
need to convert microsoft date to yyyymmdd 2
Concatenate 1
How to concatenate text & date 5
Why does this work? 7
Excel Date 4
Concatenate 7
how to generate a date in barcodefont? 1

Back
Top