| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I include TEXT in the same cell with a FORMULA?
I have a cell containing the formula "=TODAY()" . This formula returns and
displays the current date in the cell. I want to ADD the TEXT "Today's Date" to the SAME CELL without interfering with the functioning of the formula. Is it possible to do this in Excel? If so, what is the procedure? THANKS in advance to anyone who knows the answer and can post it here! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I include TEXT in the same cell with a FORMULA?
Maybe something like this:
="Today's Date "&TEXT(TODAY(),"m/dd/yy") HTH, Paul "NJCHAZ" wrote in message ... I have a cell containing the formula "=TODAY()" . This formula returns and displays the current date in the cell. I want to ADD the TEXT "Today's Date" to the SAME CELL without interfering with the functioning of the formula. Is it possible to do this in Excel? If so, what is the procedure? THANKS in advance to anyone who knows the answer and can post it here! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I include TEXT in the same cell with a FORMULA?
=Today's Date "&TEXT(TODAY(),"mm/dd/yy")
-- Regards, Peo Sjoblom "NJCHAZ" wrote in message ... I have a cell containing the formula "=TODAY()" . This formula returns and displays the current date in the cell. I want to ADD the TEXT "Today's Date" to the SAME CELL without interfering with the functioning of the formula. Is it possible to do this in Excel? If so, what is the procedure? THANKS in advance to anyone who knows the answer and can post it here! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I include a picture in a formula i.e. if cell a26 >90% then s. | Excel Discussion (Misc queries) | |||
| vlookup to include text | Excel Worksheet Functions | |||
| adding cells which include numbers and text | Excel Discussion (Misc queries) | |||
| Adding up cells that include text in them | Excel Discussion (Misc queries) | |||
| blank cells that include text | Excel Worksheet Functions | |||
Linear Mode
