Text String and Date Formula

[Hayesk]

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

 

[Aladin Akyurek]

On 2002-03-25 02:15, Hayesk wrote:
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 "&TEXT(TODAY(),"mm/dd/yy")


Change the "mm/dd/yy" bit into one that you prefer.

 

[Ivan F Moala]

On 2002-03-25 02:15, Hayesk wrote:
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

Try

="Transactions as of " & TEXT(TODAY(),"dd/mm/yy")

Ivan

 

[Hayesk]

Thanks, works like a charm.