Excel Formula

R

Rick

I am trying to have text and a formula reside in teh same box with the
date in the format shown (23-May-04). Here is as far as I get...

="Todays date is "&TODAY()

and the results I get is

Todays date is 38131

Rick
 
D

Dave Peterson

Or you could give that cell a custom format and just enter the date:

Try:
"Today's date is: "mm/dd/yyyy

As your custom format (Format|cells|number tab|custom category)
 
R

Rick

Found solutions after some weekend reading.

="This is a sample conversion - "&TEXT(NOW(),"dd mmmm yyyy")

Rick
 
D

Dan Chupinsky

This worked for me. Use the formula =TODAY() and the format the cell with
custom format "
todays date is"* d mmmm yy. Good luck.

Dan
 
Top