View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Formula and Text in One Cell

=TEXT(TODAY(),"dd/mm/yy") & " hope it's a good one"

--
Gary''s Student - gsnu200738


"Luddite" wrote:

Is it possible to have a cell with a formula and still include text. It is
easy enough to generate a calendar, (basically I'm creating the calendar by
dragging a date to other cells) but once I have the calendar, I want to be
able to insert text into the individual cells. For example, in a cell that
is formatted with a date 08/23/07, is there a way to include some text such
as Abby's Birthday?