Date format not appearing in concatenate

V

Vijay Kotian

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

T. Valko

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

Biff
 
D

David Biddulph

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