Forum Widgets
Latest Discussions
Currency Formatting adding additional periods to number
Hi, This has started happening on Excel and its baffling me so I thought I'd reach out to the community to see anyone can help. This is Excel v2606 (M365) with latest updates. Issue: I have a new work book and in a cell I simply add the number 20 I right click the cell with the 20 in it and select "Format Cells.." and change it to currency and this happens If I go back into "Format Cells" the selection has moved from Currency to Custom and it shows this: And clicking on Currency the format is shown as this: No matter what I do I can't get it to format correctly, if I change the format back to "General" it goes back to being 20. I've tried doing an online repair and that hasn't had any affect. Any help gratefully received. Rob
If formula based on cell value
Not sure if an "IF" formula is the right one needed here, but this is what I am trying to do. In cell B9, I want text to display based on what is in cell I6. I have I6 set up as a list of one of the following AS, EA and PI (acronyms for Assemblies, Each and Per Install) I am trying to get the worksheet to do the following If I6 is blank, I want B9 to read "Select Unit" if I6 is AS, I want B9 to read "Assemblies" if I6 is EA, I want B9 to read "EACH" if I6 is PI, I want B9 to read "Installs" This is what I started with, but I cannot figure out how to include the rest of the conditions - =IF(I6="AS","Assemblies","Select Unit") Any help would be appreciated. Thanks,
Excel Copilot fails when local workbook filename contains #
Excel Copilot does not work with locally stored workbooks whose filename contains the '#' character. The same workbook works correctly after renaming the file to remove '#'. The same workbook also works when stored on OneDrive with '#' in the filename. The issue appears specific to local files and filename parsing. Specifically, when clicking on Copilot in Excel, Copilot says "This file type is not supported for editing with Copilot. Please save this file as a modern file format, such as ".xlsx", to be able to edit it with Copilot." Interestingly, Copilot works fine if the Excel file name contains, for example, % or &, the problem only occurs if the name contains #. We suspect this is a bug. In our workflows, we work a lot with files that have # in their names and we would be very happy if this was indeed a bug and if it was fixed. Tnx.
Stock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?
Spacing on stacked bar charts
Hi all, I searched for a solution, but changing to 'text' axis doesn't work and that's the only solution I have seen offered. Issue: When using a date axis, there is too much white space / bars are too skinny to be legible despite gap width set all the way at 0. When switching to a text axis, the bar spacing is perfect, but the spacing between dates are at times nonsensical or for some reason it thinks the range is way different than what is highlighted. Here is how the data is highlighted, I only hid columns to make the picture a reasonably proportion the screenshots from above are when no columns are hidden. Is there a way to re-scale the gap-width when using a data axis to effectively to go something like -50%? Or to somehow manipulate the range and the months between labels when using a text axis? Thank you for the help. Matt
One time purchase 2022 Office Home Edition failed to activate
I bought a 2022 Office Home Edition on a one time basis in 2022 and installed on my Mac which has worked well over the year. Then, suddenly on 13 July this year, its Excel disallowed me to save and edit, saying I need to subscribe Office 365, etc in order to activate. I don't know what is going on. Can this be fixed?One time purchase 2022 Office Home Edition failed to activate
I bought a 2022 Office Home Edition on a one time basis in 2022 and installed on my Mac which has worked well over the year. Then, suddenly on 13 July this year, its Excel disallowed me to save and edit, saying I need to subscribe Office 365, etc in order to activate. I don't know what is going on. Can this be fixed?
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with nested if and statements between 2 excel spreadsheets. I have a slightly large spreadsheet with names that are repeating and events repeating thus the file first needs to determine the class so it pulls the right time. The data contains Classes (class A, B and C), Name, Event and Time. Spreadsheet A is the times. Everyone's times are recorded on Spreadsheet A. Spreadsheet B is to track the times per participant on a different tab per participant. In Spreadsheet A, column A is the participant number, column C is event name, column G is the time and column H is the class. In spreadsheet B, (the formula will be in Spreadsheet B). First, I need the formula to look at the class listed in spreadsheet B Column C Row 4 (Class A), then the formula needs to look at column H in spreadsheet A for Class A. Then it needs to look for the rider number on spreadsheet B, Column C row 2 (1234), needs to search spreadsheet A column A for rider 1234, and last it needs to look for the event (Runs) in spreadsheet B, and searches spreadsheet A column C for runs. After it matches all 3 then it needs to return the time in column G. If it does not find all 3 matches, then it needs to leave it blank. IE: Spreadsheet B, Class "A", Rider "1234", Event "Runs", if it meets all three criteria's then return the time in Column G.
