Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Merging Cells when one cell is a date
I am trying to merge two cells using the formula: =A2&", "&B2. B2 is a date
and when it merges it switches the date to a series of numbers. I have tried changing the cell formating but I don't seem to be able to get it to merge the date without loosing it's formating. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
? on "date last saved" in cell | Excel Worksheet Functions | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |