Date label and current date in same cell
="Date:"&Text(Today(), "dd/mm/yyyy")
or even formt the cell as
"Date:"dd/mm/yyyyy
and just enter the date or the date formula
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Lost in Microbiology" wrote
in message ...
I have a worksheet where I want to have the current date with a label in
the
same cell.
Date: 01/01/2008
I tried ="Date:"&Today() but it just gave me Date:39473.
Thanks for any thoughts.
|