I would like to combine a text string with the date formula "=Today()" in a single cell such as:
="Transactions as of" Today()
When I use an "&" to contect the text string and the date formula, the results is the value of the date. How do I get the correct date format?
Thanks
_________________
This message was edited by Hayesk on 2002-03-25 02:16
="Transactions as of" Today()
When I use an "&" to contect the text string and the date formula, the results is the value of the date. How do I get the correct date format?
Thanks
_________________
This message was edited by Hayesk on 2002-03-25 02:16