Auto Insert today's date in a cell with other text

[lecxE]

In C1, I'd like to have the following appear:

Balance due as of 10/28/2005

Where the date changes to the current date automatically.

I put "Balance due as of " in Z1 and =today() in Z2 and =z1&Z2 in C1. I get "Balance due as of 38658".

Any help is appreciated.

Thanks.

 

[Smitty]

How about all in one cell:

="Balance due as of: "&TEXT(NOW(),"mm/dd/yyyy")

HTH,

Smitty

 

[Legacy 51064]

Concatenate formula works as well:

=CONCATENATE(Z1,TEXT(Z2,"mm-dd-yyyy"))

 

[lecxE]

Great answers! Just what I needed. Thanks!!!

 

[lecxE]

Great answers! Just what I needed. Thanks!!!