Excel topics

Currency Formatting adding additional periods to number

Rob-CTL — Wed, 22 Jul 2026 15:56:09 GMT

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

neilm1 — Wed, 22 Jul 2026 12:55:48 GMT

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 #

Elvis-19 — Wed, 22 Jul 2026 08:10:07 GMT

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

Carl32351 — Mon, 20 Jul 2026 21:25:54 GMT

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?

Make Office Copilot can be configured to use third-party servers and models.

HumanMusic — Sun, 19 Jul 2026 09:15:24 GMT

Really needs it. Thanks.

HOW DO I REMOTE THIS SPAM FROM EXCEL

LT — Sat, 18 Jul 2026 19:21:25 GMT

How do I remove this SPAM from office?

I pay for the product at the level I want, I don't need an upgrade and defiantly don't wan this SPAM in the product

Excel command icon to change from upper or lower case text

Jason4 — Sat, 04 Jul 2026 02:55:21 GMT

Where is the command icon for changing text from upper or lower case.

There is one in word, but none in excel that I can find.

I though this would have been a standard feature. After the 40 years of development.

Also you can not use, format painter to change the text to upper case either.

Please add this feature for the 41st anniversary

currency format Excel 360

KimC1 — Sun, 12 Jul 2026 05:04:38 GMT

I highlight a column and click on the format for "currency" and choose options for use 2 decimal places, show dollar sign, then for negative number, no minus sign, no red. Aside from the currency format tab, I choose to format the column in red and bolded using the "home" button.

The problem is this format is inconsistently applied. Sometimes it shows a leading minus sign, sometimes it shows a hidden minus sign, and sometimes there is no minus sign at all. This causes me problems when I try to total a column by highlighting it and looking on the lower right for the value. Why is it doing this and how can i stop it?

Spacing on stacked bar charts

Excellerator1 — Thu, 16 Jul 2026 17:16:08 GMT

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

kcng2018 — Thu, 16 Jul 2026 14:24:32 GMT

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

kcng2018 — Thu, 16 Jul 2026 03:07:06 GMT

Vlookup with If And statement

akerntke — Wed, 15 Jul 2026 17:06:32 GMT

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.

excel links unable to refresh on Mac M5

raameeson — Wed, 15 Jul 2026 13:07:48 GMT

I get the above error message on a Mac M5 when I click refresh on the links.

Compute elapsed time

JAV6 — Wed, 15 Jul 2026 13:04:37 GMT

I have a spreadsheet of charging time for my Jeep. I would like to calculate the duration of the charging period but am having problems coming up with a formula that would work. It would have to account for the minutes where the start time minute is greater than the end time minute. Unless someone has another way of computing this.

Grouping data sourced from another sheet in that workbook.

Ceddster — Wed, 15 Jul 2026 08:19:40 GMT

I am trying to make a monthly inventory count workbook through excel nut am having trouble consolidating the counts. I have a made a simple version of what I need but am getting stuck on the final sheet trying to group the data together.

In my workbook I have a sheet with all my input data which I have attached below. I have fed this through PowerQuery so that the information from this Sheet can go into all other sheets on that workbook, and I only need to update one Sheet if new stock comes in, or leaves.

From there I have the "Bar" Sheets where the counts get entered. As I will be dealing with a lot of stock, felt better to make a "Loose" & "Cartons" column and then just sure make an extra column where the calculations can be made giving a full total amount.

Last Sheet is where I would like to consolidate all the totals from the "Bar" sheets into one area. which I have used the formula ="SheetName"[@Cell] as I do not know any other ways of bringing across this data.

And here lies the problem. As on the "Full Stock List" sheet i have cells that are not actual values, the rows are not grouped, and if I try to sort by Item Name alphabetically, only the original 5 columns will sort, leaving the new columns untouched.

If anyone can help explain how I can get around this, that would be most helpful, as I need to make this Workbook much much bigger.

Contest Scoring

gmason96 — Wed, 15 Jul 2026 04:48:39 GMT

I created a spreadsheet to calculate points for a Skillathon test we give to kids at our fair. On the main sheet, we input the points earned for each question.

I created a second sheet to calculate the points for question 20. I have a table set up to auto-sort the teams by Amount. I want to be able to take the points from this table and have that input into the main score sheet.

Need help with the function for this.

Copy a formual, locking 1 data cell

JeffPeda — Tue, 14 Jul 2026 21:33:57 GMT

Hello

I have this formual to calculate the value in cell F11. I woul like to copy the formula down to F12, 13, 14, 15 and 16. Needing to lock the cell F5 value in the formula. Copy and paste only changes for F% to F6 to F& and so on. Thank you

=(D11-(B11+F5)-(G11)+C11)/D11

COUNTIFS

Tazfremont — Tue, 14 Jul 2026 02:00:32 GMT

Can I change the output of a COUNTIFS function to a different cell? I would like it to calculate in one cell and output the result to another cell for easier copy and paste procedures.

Fixing Hyperlinks in a Copied Worksheet (on an Apple Mac)

scrail2004 — Mon, 13 Jul 2026 20:12:16 GMT

I have scoured this forum’s discussions about hyperlinks in a copied worksheet referencing back to the original sheet. Perhaps I missed it, but I didn’t find a solution to my specific problem, so I will start a new discussion. Apologies if a community wizard already answered it.

I have a workbook with monthly worksheets, each showing the transactions into and out of a savings account. Each transaction goes into (and out of) one of several “virtual” accounts to reflect the purpose for which the money is earmarked, like property taxes, travel, etc. (called Account 1, Account 2, and so on in the attached)

Each month’s worksheet has a section of hyperlinks, each of which ideally jumps to a specific account in the same worksheet. The attached example contains only four accounts, but my actual one has 23 with 31 columns and 98 rows. So the hyperlinks are helpful in navigation.

Each month, I make a copy of the latest worksheet and rename it for the new month.

The problem: the hyperlinks in the new, copied worksheet reference back to the “source” worksheet. With 23 hyperlinks, changing each one’s sheet reference (Edit Hyperlink...) every month is not efficient.

Question: how can I (efficiently) make the hyperlinks in the new worksheet reference cells in their new worksheet?

These are hyperlinks that are internal to the workbook, not to external URLs, so DonBici’s Feb 21, 2024 suggestion of a helper column doesn’t seem like it would work in this case, and I am not advanced enough for his VBA suggestion.

Thanks!

Runt-time Error 1401 When Importing a CSV file Using VBA

Contrail1234 — Sun, 12 Jul 2026 18:47:30 GMT

I am beyond frustrated that I cannot make this work. Let me explain.

My spreadsheet needs to import a standard CSV file then parse that information into several different worksheets. The very first time I ran the import code it worked. The second time and every time after that it fails with the "Run-time error '1004': Application-defined or object-defined error" message. I tried this on a different computer with the same results first run it worked, every run after that it fails.

Here is the code:

Sub ImportCSV() Dim ws As Worksheet Dim csvFilePath As String Dim lastRow As Long ' Set the worksheet where you want to load the data Set ws = ActiveWorkbook.Sheets("Raw") ' Specify the path to your CSV file csvFilePath = "exportusers-all.csv" ' Clear existing data in the worksheet ws.Cells.Clear ' Import the CSV file With ws.QueryTables.Add(Connection:="TEXT;" & csvFilePath, Destination:=ws.Range("A1")) .TextFileParseType = xlDelimited .TextFileCommaDelimiter = True .Refresh End With End Sub

This is the code I've found in numerous places when I search the internet when I search how to do it. I have tried this as a normal user and "Run as Administrator" both fail.

My Trust Center > Macro Settings are as follows:

Enable VBA macros - Selected
Trust access to the VBA project object model - Checked

The CSV file can be opened in a text editor and Excel without any issues, but if I try to import it, it fails completely. Any help or suggestions to resolve this problem would be greatly appreciated. Thanks.