="my text" &TODAY()

[Guest]

The above will return a date value (regardless of how I format the cell it's
in) rather than the date. Clever as this is, it's of no use to me whatsoever.
What I want is:
Logged today - 03/Jul but what I get is Logged today - 39267

Answers on a postcard please...

 

[Guest]

Try:-

="Mytext " & TEXT(TODAY(),"dd:mm:yyyy")

Mike

 

[Guest]

Thanks Mike. You saved the day yet again. Brill.
Jock