Formatting cells to show two dates in one cell
 

I have a column in my spreadsheet that is for the date that I recieve info
from clients. When I recieve this info on more than one date, I've been
putting a comma between the two dates.

I have a word document that I use merge to pull this information (along with
other info), but when I pull the data from this particular column, it changes
the dates to something like 12:00AM. I've tried changing the formatting of
this column to text and also to general, but it still will not give me just
the two dates.

I don't want to create another column for the second date, because the
spreadsheets is already a bit unwieldy.

Formatting cells to show two dates in one cell
 

You won't be able to achieve this through formatting the cell. Once
you add the comma and a second date then Excel will treat that as a
text entry, and formatting can't change that.

Hope ths helps.

Pete

On Dec 29, 4:16*pm, Jo4321 wrote:
I have a column in my spreadsheet that is for the date that I recieve info
from clients. *When I recieve this info on more than one date, I've been
putting a comma between the two dates. *

I have a word document that I use merge to pull this information (along with
other info), but when I pull the data from this particular column, it changes
the dates to something like 12:00AM. *I've tried changing the formatting of
this column to text and also to general, but it still will not give me just
the two dates. *

I don't want to create another column for the second date, because the
spreadsheets is already a bit unwieldy. *

Formatting cells to show two dates in one cell
 

Well, this is the problem: I WANT it to be treated as text, but it is not
working.

I want it to show up on the merged document as "3/11/2009, 12/29/2009".
However, even though it looks that way on the excel document, when I use
merge to pull it into the document, it changes it to 12:00AM or similar.

Besides changing the format on the excel sheet to text, I also tried adding
an apostrophe at the beginning, but that didn't work either. I'm wondering
if it is something I have to do within the word document.

Jo



"Pete_UK" wrote:

You won't be able to achieve this through formatting the cell. Once
you add the comma and a second date then Excel will treat that as a
text entry, and formatting can't change that.

Hope ths helps.

Pete

On Dec 29, 4:16 pm, Jo4321 wrote:
I have a column in my spreadsheet that is for the date that I recieve info
from clients. When I recieve this info on more than one date, I've been
putting a comma between the two dates.

I have a word document that I use merge to pull this information (along with
other info), but when I pull the data from this particular column, it changes
the dates to something like 12:00AM. I've tried changing the formatting of
this column to text and also to general, but it still will not give me just
the two dates.

I don't want to create another column for the second date, because the
spreadsheets is already a bit unwieldy.

.

Formatting cells to show two dates in one cell
 

Try using a different separator in Excel, maybe "~". Then use Find and Replace
in Word to change it to a comma.

Jo4321 wrote:
Well, this is the problem: I WANT it to be treated as text, but it is not
working.

I want it to show up on the merged document as "3/11/2009, 12/29/2009".
However, even though it looks that way on the excel document, when I use
merge to pull it into the document, it changes it to 12:00AM or similar.

Besides changing the format on the excel sheet to text, I also tried adding
an apostrophe at the beginning, but that didn't work either. I'm wondering
if it is something I have to do within the word document.

Jo



"Pete_UK" wrote:

You won't be able to achieve this through formatting the cell. Once
you add the comma and a second date then Excel will treat that as a
text entry, and formatting can't change that.

Hope ths helps.

Pete

On Dec 29, 4:16 pm, Jo4321 wrote:
I have a column in my spreadsheet that is for the date that I recieve info
from clients. When I recieve this info on more than one date, I've been
putting a comma between the two dates.

I have a word document that I use merge to pull this information (along with
other info), but when I pull the data from this particular column, it changes
the dates to something like 12:00AM. I've tried changing the formatting of
this column to text and also to general, but it still will not give me just
the two dates.

I don't want to create another column for the second date, because the
spreadsheets is already a bit unwieldy.
.