Mail Merge Dates Issue
I have an Excel Sheet that includes dates. I have created a Word Mail Merge Document that includes the merging of dates and other information from the Excel Sheet. In the merge, all data other than the dates are merging correctly. The dates are merging in as numbers, regardless of switches. I do not understand why I am having so many problems with this date issue. The date clearly shows as a date in Excel yet its merging in as numbers. No matter what I try, I cannot get the Date to merge in as the Date shown in Excel. How can I make this work. Carl
Sharepoint Hyperlink not Dynamic
Recently a bunch of items were moved from a drive to Sharepoint and I am trying to update my dynamic hyperlinks. Every month there is a checklist of tasks that need to be accomplished and I have Hyperlink formulas to click on and go to the current month-year folder. I setup my formula using the "December 2024" folder as my basis and the formula sent me there. Perfect! Then I changed the MONTH_YEAR cell to "December 2023". The only difference between the file paths when copied and pasted from the address bar is 2023 versus 2024. When I clicked on the updated link it sent me right back to the 2024 folder. Does anyone know why the link isn't changing when I change the parameters? =IFERROR(HYPERLINK(CONCAT(http_to_Master_Folder, "%2F%5F%5FCharacter%2FCY", RIGHT(MONTH_YEAR,4), "%2FNotes&viewid=x00000f2%2X0x0x%2XD0xxx%0Xx00x%0X0000x000xx00"), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), " > Notes")), CONCAT("Game > Campaign > Player > Character > CY", RIGHT(MONTH_YEAR,4), "> Notes")) Thank you
Excel for Mac - Run-time error '1004': Method 'Name' of object 'Addin' failed
Dears, Whenever I open any Excel File (existing or blank), I get the following error message: "Visual Basic for Applications Run-time error '1004': Method 'Name' of object 'Addin' failed" Note: I don't have any VBA code in the file - again, this message also appears when opening a blank/new/empty file. I thought it could be related to one of the Add-ins that I had installed, but even after removing all of them, the message still appears. Does anybody know what it means and how to fix it? I'm running Excel for MacVersion 16.91 (24111020) from Microsoft 365 in macOS SequoiaVersion 15.1.1. Thanks in advance, Andre
Need To Convert Data In Cell To Date and Time
Hello, normally I am pretty good at writing my own formulas, but for some reason this one has me a little stumped. We have a website with forms that clients enter information in, and that info is setup to automatically enter that data into a spreadsheet we have in our Google folder. What I need is a formula to convert the raw data into a format we can use. The cell below is what I am hoping to build a formula for. First, the date and time is there... However, here is the challenge... it is in Zulu Time which is 8 hours ahead. So I need help writing a formula to give me as follows... A1 A2 Is there ANY way this can be done with a formula? Thank you so much for your help in advance. I do sincerely appreciate it.
