Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in Excel displays incorrectly when merged in letter
We are trying to mail merge from Excel. One of the fields we want to use is
a date field. In Excel, the date displays correctly in the cell (i.e. September 1, 2001); but in the function bar at the top of the page, it display 9/1/2001). So, when it merges, it has the 9/1/2001 on the letter. How do we get it to display correctly in mail merge? We've tried the Custom feature from the category list. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
date in Excel displays incorrectly when merged in letter
Feather 52 wrote:
We are trying to mail merge from Excel. One of the fields we want to use is a date field. In Excel, the date displays correctly in the cell (i.e. September 1, 2001); but in the function bar at the top of the page, it display 9/1/2001). So, when it merges, it has the 9/1/2001 on the letter. How do we get it to display correctly in mail merge? We've tried the Custom feature from the category list. You need to put some date formatting codes in the merge field. \@ "MMMM, d yyyy" should do it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How change Excel default date format to something useful | Excel Discussion (Misc queries) | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |