| 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. |
|
#2
|
|||
|
|||
|
=A2&", "&TEXT(B2,"mm/dd/yy")
HTH Jason Atlanta, GA -----Original Message----- 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. . |
|
#3
|
|||
|
|||
|
try
=A2&text(b2,"mm/dd/yy") Duke "Patti Bowles" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
