Date to text conversion

  • Thread starter Thread starter ginnyst
  • Start date Start date
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?
 
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
 
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,
 
Another way if you want today's date


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


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

format text to date results in ############## 4
Using IF function to perform calculation after specific date 1
Conditional formatting in Excel 2010 2
Date conversion issue 3
Excel Formatting with dates 3
How to use index and match function for determining the value? 1
Date to text/number Conversion 1
Average problem 1

Back
Top