how do you write format results of a function within a function? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              sangee 6/13/2007 1:00 PM PST   Question   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?     Was this post helpful to you?         Reply |   Top           Mike H 6/13/2007 1:10 PM PST   Try this =A1&" "&TEXT(B1,"dd-mm-yyyy") Text in a1 and date in B1 Mike "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?     Was this post helpful to you?         Reply |   Top           Teethless mama  6/13/2007 1:16 PM PST   Answer   ="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?     Was this post helpful to you?         Reply |   Top           sangee 6/13/2007 4:44 PM PST   Thanks Mike H and Teethless Mama. Right after this post I searched again and good old google came to my rescue as well "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?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies