| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate with the formula values
When I, concatenate the values of two cells, Cell A1 contains the text
"Payables for the month of " & Cell B1 Contains the formula Value of Date". When Concatenated the two cells the value in cell B1 is shown in number format and not in date format as displayed in the cell. How to get the date format ? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate formula or & | Excel Discussion (Misc queries) | |||
| Concatenate values | Excel Worksheet Functions | |||
| Need help with concatenate formula | Excel Worksheet Functions | |||
| Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions | |||
| concatenate values/texts corresp. to a searched repeated value/tex | Excel Worksheet Functions | |||
Threaded Mode
