Date Format
You can save one concatenation operation by moving the slash into one of the
format patterns, for example...
=TEXT(A1,"DD-MMM-YYYY/")&TEXT(A2,"DD-MMM-YYYY")
--
Rick (MVP - Excel)
"Elton Law" wrote in message
...
Dear Expert,
Maybe for you,it's easy ... but I really cannot make it.
Cell A1 is Date 21-Feb-1994
Cell B1 is Date 23-Mar-1994
I used A1&"/"&A2. I give a chance of numbers.
I just want to display 21-Feb-1994/23-Mar-1994.
Can you advise how to?
|