Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. * |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cells to show dates as the day of the week | Excel Discussion (Misc queries) | |||
conditional formatting or formulae to show elapsed dates | Excel Worksheet Functions | |||
How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
show nearst of two dates in new cell on excel | New Users to Excel | |||
Formatting to show/not show "DUE" and "RECEIVED" in cell | New Users to Excel |