Thread: Format Date in Cell with Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H. Mike H. is offline
external usenet poster
  
Posts: 471
Default Format Date in Cell with Text
I have a named range, DT, which contains a date value. I wish to display in
a cell:
="Revenue Account Summary As Of " & DT
But I get "Revenue Account Summary As Of 39566". How can I format the Dt in
the cell?
Reply With QuoteReply With Quote