CONCATENATE Formula
If it's anything like E2003 then try:
=TEXT(A1,"dd:mm:yyyy")&TEXT(B1,"dd:mm:yyyy")
Mike
"jtinne" wrote:
I'm trying to use this formula in Excel 2007. I have 5 cells I'm combining
and 1 of the cells uses the - TODAY() - formula. When concatenate returns
the value for this cell, it only displays numbers. How do I make this cell
return the date instead? Any help is appreciated.
|