how do you write format results of a function within a function?
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?
|