Thread: how do you write format results of a function within a function?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default how do you write format results of a function within a function?
="Today date is "&TEXT(TODAY(),"m/d/yyyy")


"sangee" wrote:

Hi - I would like the following "Todays date is" & today() to be displayed as
Todays date is 6/13/2007. the today() resolves to the system number. how can
I write the format in the concatenate function?
Reply With QuoteReply With Quote