Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatinating text plus cell containing date
I am trying to combine a text string ("FOR THE PERIOD OF "), then do a cell
reference to another sheet within the same workbook. The cell contains a date. The result in the concatinated cell only displays as the date (39366, etc.). I've trying using format cell, using both the date option and the special option with no success. Also tried both "=concatinate" and using the ampersand (&) with same (incorrect) result. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatinating text plus cell containing date
Try something like:
="FOR THE PERIOD OF " & Month(cell reference) & "/" & day(cell reference) & "/" & year(cell reference) HTH, Paul -- "Lori" wrote in message ... I am trying to combine a text string ("FOR THE PERIOD OF "), then do a cell reference to another sheet within the same workbook. The cell contains a date. The result in the concatinated cell only displays as the date (39366, etc.). I've trying using format cell, using both the date option and the special option with no success. Also tried both "=concatinate" and using the ampersand (&) with same (incorrect) result. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatinating text plus cell containing date
In a worksheet:
="For the period of " & Text(A1,"mmm dd yyyy") Change the 2nd argument to reflect the date format you want. In VBA/macros you'd replace the Text function with the Format function (same arguments). "Lori" wrote in message ... I am trying to combine a text string ("FOR THE PERIOD OF "), then do a cell reference to another sheet within the same workbook. The cell contains a date. The result in the concatinated cell only displays as the date (39366, etc.). I've trying using format cell, using both the date option and the special option with no success. Also tried both "=concatinate" and using the ampersand (&) with same (incorrect) result. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert a text cell into date cell in Excel | Excel Discussion (Misc queries) | |||
Cell colors or text color changing when date in cell gets closer. | Excel Worksheet Functions | |||
Concatinating a string of numbers - how? | Excel Discussion (Misc queries) | |||
Text & Date same cell | Excel Discussion (Misc queries) | |||
date in a text cell | Excel Discussion (Misc queries) |