View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default Why Not in a Single Cell

On Monday, May 28, 2012 7:38:33 PM UTC-4, James Ravenswood wrote:
If I enter:
5/28/2012 in A1
and
02:15:45 in A2
then =A1 + A2 works just fine, but if I enter:
=5/28/2012 + 02:15:45 in a cell I get an error.

Why?


Thanks to all of you!