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