Date question

M

M Thompson

Hi

I'm trying to combine the word "Date:" with the TODAY() feature, so that it
looks like Date: 6/6/09. Can someone help?

Thanks and have...
 
M

MyVeryOwnSelf

I'm trying to combine the word "Date:" with the TODAY() feature, so
that it looks like Date: 6/6/09. Can someone help?
Click to expand...

One way is to put this in the cell
=TODAY()
and use
Format > Cells > Custom >
with this in the Type:
"Date: "m/d/yy

This way, the cell is still a numeric date and it can be used in date
calculations.
 
M

M Thompson

Good idea. Thanks!
--
OneFineDay


MyVeryOwnSelf said:
One way is to put this in the cell
=TODAY()
and use
Format > Cells > Custom >
with this in the Type:
"Date: "m/d/yy

This way, the cell is still a numeric date and it can be used in date
calculations.
Click to expand...
 
Top