Hello,

I have a word document with some link fields I am trying to format. The fields in excel are formatted with a date format of MMM-yy, but I want them to show in Word as MMMM yyyy. Here is the field code in Word:

{ LINK Excel.SheetMacroEnabled.12 "\\\\fs-01\\My Documents\\JOB FILE FOLDER\\2023\\23-060.xlsm" "LMT!R6C3" \a \t \@ "MMMM yyyy" }

The cell in Excel looks like this May-23, and the field in Word displays May 2023. This is as it should be. The problem occurs when I link another cell with a date from one year earlier.

In Excel, the date is May-22, and if I don't add the date switch, it displays May-22 in Word. When I add \@ "MMMM yyyy" to the switch, it displays May 2023.

Here is the field code:

{ LINK Excel.SheetMacroEnabled.12 "\\\\fs-01\\My Documents\\JOB FILE FOLDER\\2023\\23-060.xlsm" "LMT!R6C4" \a \t \@ "MMMM yyyy" }

Why does it show the current year?