Numbers Insert Stock Quotes Function Currency format infects my spreadsheet

By "infect" do you mean the formats of other cells are affected by the Currency format? If so, have a look at the workarounds in this user tip by Ian (Yellowbox). I think using the VALUE() function to convert from Currency to "just a number" will be the solution for you in this case.

SG

Yes, that's a known issue in the latest version (4.3). VALUE() should help.

And if you can be sure to give feedback to Apple at Numbers > Provide Numbers Feedback in your menu.

SG

Hi,

I have a similar issue but It doesn't involve stock prices. I hadn't noticed it until recently so this may be a new bug.

The sum of a column returns ($ Total Gross). In my formula I divide that by a number (Goal) and set the cell to return (% of Goal Met) but it returns currency.

I tried using (Value (Total Gross / Goal)) to return (% of goal met) but it still returns the right number but the wrong format.. In this case the cell should return 95% but it returns $0.95 and it won't let me change the format.

Then I take (% Days of the Year) and divide it by (% of Goal Met ) to return the (% of Goal to Date) which tells me if I am currently ahead or behind where I should be to reach my goal.

Again, I get the right number but the wrong format. So instead of 113% it returns $1.13.

If I eliminate the formula for (% Goal Met) and just type in 95%, (% of Goal to Date) it will return %.

So, it seems if any cell in a formula is currency the end result will only return currency.

How is one to determine the percent difference between two dollar amounts if Numbers won't return percent and only returns currency?

Any ideas? Thanks

Did you read Ian's user tip linked to above?

SG