Numbers 4.3 new Currency formats/functions

Question

Level 7

21,939 points

Numbers 4.3 new Currency formats/functions

Hi fellow Numbers users,

The update to Numbers 4.3 has caused some documents to "misbehave". Numbers 4.3 sometimes will only allow a "Data Format" of "Automatic" that will reflect only the currency of the source cells and can not be converted to another currency. Bugga!

Many replies have encouraged Feedback to Apple. That is the right thing to do. However, please be aware that the Apple employees who read your feedback are people. Apple employees will read your feedback, but who can blame them if they place a rant on the bottom of their inbox? Be polite, describe the problem and explain how an improvement will benefit you and other users of Numbers 4.3.

Please help your fellow users in this forum to help you. Give full details of your problem. Screen shots and formulas will help.

Some suggestions (workarounds) so far in this forum include:

Use Number values instead of a Currency format. The header cell can act as a Currency label without 'controlling' the body cells.
Use Custom Formats to give the appearance of a Currency value whilst acting as plain numbers.
Explore the functions in Numbers 4.3
Type = in a spare cell to bring up the Function Browser. Click on Financial and explore the various functions. You may be pleasantly surprised.

I am sure that I have missed something, because every user has a different aim.

Positive replies are welcome.

Regards,

Ian.

macOS Sierra (10.12.4), null

Posted on Sep 27, 2017 7:23 AM

Reply

Answer 1

stfflspl

Level 3

593 points

Sep 30, 2017 4:42 AM in response to SGIII

Another small contribution as I wrote in a previous conversation:

Using Numbers 4.3, I have no problems calculating a profit/loss % based on two currency values.

The values in column B & C are formatted as currency (€, 2 decimals).

The values in column D are formatted as a percentage (%, 0 decimals), although the source values are both formatted as currency.

Paul.

Reply

Answer 2

SGIII

Level 8

37,550 points

Sep 30, 2017 4:43 AM in response to Yellowbox

Hear! Hear!

(I include the link to show why I think that expression means the same in Australia as it does here; I'm often unsure about these things.🙂)

And one small addition:

If one cannot avoid using the Currency data format, as when using the CURRENCY() and CURRENCYCONVERT() functions, then keep in mind that the VALUE() function usually works to convert the results of CURRENCY() or CURRENCYCONVERT() to Number format.

SG

Reply

Answer 3

Yellowbox Author

Level 7

21,939 points

Sep 30, 2017 4:53 AM in response to Barry

Barry wrote:

Hi Ian,

You might also want to include the suggestion regarding reverting to Numbers 4.2 for the duration.

SG wrote:

Hi Barry,

Don’t think reverting is a great option, unless using Numbers on an unconnected Mac. Will the older version play well with Numbers for iOS, where it’s not so easy to revert?

I think that this requires a new discussion or a new User Tip 😉.

Regards,

Ian.

P.S. The new Financial functions are also available in Pages 6.3 👿.

Reply

Answer 4

SGIII

Level 8

37,550 points

Sep 30, 2017 7:18 AM in response to Yellowbox

Yellowbox wrote:

P.S. The new Financial functions are also available in Pages 6.3 👿.

Hi Ian,

And, to my surprise (since I haven't used it much) Keynote has functions as well, including the new financial functions in v 7.3.

SG

Reply

Answer 5

Yellowbox Author

Level 7

21,939 points

Sep 28, 2017 5:44 AM in response to stfflspl

Thanks SG and Paul,

Now converted to a User Tip:

Numbers 4.3 new Currency formats/functions

Please comment.

Regards,

Ian.

Reply

Answer 6

Barry

Level 9

60,023 points

Sep 29, 2017 7:09 PM in response to Yellowbox

Hi Ian,

You might also want to include the suggestion regarding reverting to Numbers 4.2 for the duration.

Regards,

Barry

Reply

Answer 7

SGIII

Level 8

37,550 points

Sep 29, 2017 7:27 PM in response to Barry

Hi Barry,

Don’t think reverting is a great option, unless using Numbers on an unconnected Mac. Will the older version play well with Numbers for iOS, where it’s not so easy to revert?

SG

Reply