View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve D Steve D is offline
external usenet poster
 
Posts: 22
Default Formatting the value of a cell reference in a formula

I am trying to use a formula to concatenate 2 cells, one is text and the
other is a date. When I enter the formula the date appears as a number. Is
there a way to format just the cell that contains the date to show as a date?
--
Thank You,
Steve