Forum Widgets
Latest Discussions
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
Multiple filter in a pivot table to show the best "x" values using slicers
I have a pivot table with the following fields Row Fields Level 1 Level 2 Empl code Empl name Value Field Ranking By slicers, I make filters for the fields Level 1 and Level 2. I need to get the best x (e.g. the top 10) from the filtered lists based on the value of the Ranking field. don't know if it can be done with slicer, although it would also be useful to group the ranking by brackets (for example 1-10, 11-20....) and create a slicer with these brackets to filter the list. Thnks in advance.
Why does Excel STILL automatically remove zeroes at the start of numbers I export into the program?
Seriously, who designed this godawful application? It's needlessly "helpful", just auto-formatting all my information into whatever dumb setting it wants. I have to export 500 barcodes into a sheet and organize them but of course Excel HAS to jump in and remove ALLLLLLLLL the zeroes at the start so I need to waste my time going in and formatting all the cells to "text" (otherwise they'll just keep "helpfully" re-formatting all my data without asking me). Oh man, and don't even get me started on trying to type the number "102320241016" into a cell. For some reason Excel decided that should be a scientific notation and constantly changes it to "1.0232E+11". Honestly why is this a feature? Who thought that we'd all want this? Why is EVERY Microsoft product I am forced to use for job so excessively anti-user? Between excel, teams, and outlook like an hour of my day ends up being spent trying to parse my way through these bloated, poorly running applications. It's like they're all designed to try and help but the way they "help" is by being as annoying and in the way as possible which just ends up slowing down everyone who actually knows what they're doing.
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 graphing help to show grouped data
Hi there, I would like to make a stacked bar chart to display this data but I would like, for example, the Kimberley 2020 information to be on top of the Kimberley 2015 information, the Cranbrook 2020 information to be on top of the Cranbrook 2015 information, etc. Can you please advise me how to do that? Thanks!
