Numbers 3.0 currency format

Hi Jan-Peter,

See the helpful user tip by Ian (Yellowbox) (and give it a 'like' if you like it).

I do not believe there is a TRUNCATE() function in Numbers (at least not when the language is set to English) so it's unclear how that could have solved your problem.🙂

To convert from something already formatted as Currency, I'd use VALUE(), or ROUND()

For new documents, I simply use a Custom Format made to look just like currency. It's easy to do and it avoids the whole problem.

SG

Using the ROUND function (up to e.g. two decimals with a conversion rate of 4 decimals) is even more useful:

Paul.

Hi SG,

Like CONCATenate, TRUNCate has been shortened.

Regards,

Barry

I found a workaround ... What I do is apply the truncate function and it also strips the currency ...

So, if A1 cell has $ currency, B1 has € currency and C1 has the exchange rate (automatic format), in D1 you could do:

=truncate(A1,2)*C1+truncate(B1,2)

You can apply the € currency to D1 ...

great job.. How absurd that you cannot multiply currencies with FX rates anymore without such a workaround.