In cell AW14 I have the following formula: =IF(AV14="","",AU14 & " " & AV14)
Where AU14 = 2014-08-01 (formatted as date)
and AV14 = 11:20:00 AM (formatted as time)
In AW14 I expect the formula to give me 2014-08-01 11:20:00 AM but it give me a number representation.
I tried formatting AW14 as text, but same thing. I also tried the following, but it gives me an error:
=IF(AV14="","",CStr(AU14 & " " & AV14))
Any help will be appreciated