I have text in column 1, a date in column 2 and in column 3 I wish to
show the text followed by the date.
I have tried both Concatenate and & but the the result is text followed
by the underlying number representing the date. I cannot seem to format
this column to show the date as dd/mm/yy. Any suggestions?

Regards

="Today is: "&TEXT(A1,"mm/dd/yyyy")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"newman" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
|I have text in column 1, a date in column 2 and in column 3 I wish to
| show the text followed by the date.
| I have tried both Concatenate and & but the the result is text followed
| by the underlying number representing the date. I cannot seem to format
| this column to show the date as dd/mm/yy. Any suggestions?
|
| Regards

Example for text in Cell A1, date in cell B1: In C1, enter the formula

=A1&TEXT(B1,"dd/mm/yy")

Then copy downwards the formula for the range you wish to use.

Kind regards,
Erny

"newman" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
>I have text in column 1, a date in column 2 and in column 3 I wish to
> show the text followed by the date.
> I have tried both Concatenate and & but the the result is text followed
> by the underlying number representing the date. I cannot seem to format
> this column to show the date as dd/mm/yy. Any suggestions?
>
> Regards

Niek Otten wrote:
>
> ="Today is: "&TEXT(A1,"mm/dd/yyyy")
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "newman" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> |I have text in column 1, a date in column 2 and in column 3 I wish to
> | show the text followed by the date.
> | I have tried both Concatenate and & but the the result is text followed
> | by the underlying number representing the date. I cannot seem to format
> | this column to show the date as dd/mm/yy. Any suggestions?
> |
> | Regards

Thanks

I have one other question.

I have modified your info to also show the time using the now()
function.

However I have to press F9 to recalc this when I need to see the correct
time in the cell. Is it possible to have an automatic recalc occur at
set intervals or alternatively when that particular worksheet becomes
the active one?

Regards