Thread: Dates as text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lightbulb lightbulb is offline
external usenet poster
 
Posts: 61
Default Dates as text

using a formula, I am combining a column heading and the date in that row, so
that the cell will read "Column Heading Date", but the date is showing as a
number rather than a date. I want the cell to contain both txt (column
heading), and a date. How do I format it to do so?