| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text & Date in the same Cell???
Hi, is it possible to have text & a date in the same cell?? In A! I have todays date =today(). In D1 I want the statement, "Balance at (today's date). I have tried =concatenate("Balance at" , & A1) but it returns a numerical value for the date bit??? Cheers Paul. -- tallpaul ------------------------------------------------------------------------ tallpaul's Profile: http://www.excelforum.com/member.php...fo&userid=8453 View this thread: http://www.excelforum.com/showthread...hreadid=518014 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| HOW TO KEEP TEXT FROM MOVING OUT OF A CELL? | Excel Discussion (Misc queries) | |||
| Can you keep text from one cell showing over the next cell? | Excel Discussion (Misc queries) | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Threaded Mode
