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 |