Date to text conversion

G

ginnyst

I have a date (11/30/2007) stored in a cell on my worksheet. In another cell
I would like to display "Today is 11/30/2007" using the stored cell value.
Is there a function I can use to do this?
 
R

Ray

Hi Ginny -

No need for a function to do this ... just link the 1st cell into the
2nd cell (ie, in D3, enter =A3) and then use a custom format on cell
D3.
Format>Cells...>Number-Custom>"Today is "MM/DD/YYYY
 
P

Pranav Vaidya

Hi ,

Assume your date is in cell A1 and is in the format mm/dd/yyyy, then type
the below formula in target cell

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

HTH,
 
P

Peo Sjoblom

Another way if you want today's date


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


--


Regards,


Peo Sjoblom
 
Top