Date format not appearing in concatenate
 

How to get the actual date format while concatenate formala is applied. I am
getting value of date instead of DATE. Pl. help me

Date format not appearing in concatenate
 

Post your formula. Also, what is the format of the source cell? mm/dd/yy,
yyyy-mm-dd, etc.

Biff

"Vijay Kotian" wrote in message
...
How to get the actual date format while concatenate formala is applied. I
am
getting value of date instead of DATE. Pl. help me

Date format not appearing in concatenate
 

You'll need something like =A1&TEXT(B1,"dd/mm/yyyy")
Adjust the format spec in the TEXT function to suit.
--
David Biddulph

"Vijay Kotian" wrote in message
...
How to get the actual date format while concatenate formala is applied. I
am
getting value of date instead of DATE. Pl. help me