View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John T Kennedy[_2_] John T Kennedy[_2_] is offline
external usenet poster
 
Posts: 12
Default Date converts to number when part of a formula

Cell A1 contains text. Cell B1 contains a date (08/06/2008), and cell C1
contains text. I want to combine the cells into one cell.

I know to use =(A1&" "&B1&" "&C1) as the formula. However, every time I use
that forumla, i get 39666 instead of the date I actually wanted. The text
transfers nicely to my new combined cell, but I just can't figure out how to
make the date copy.

Your help is appreciated!