Translations:Basic Excel/103/en
Currency
As a general rule, currency data should be entered as a simple number, and the appropriate currency or accounting format should be applied to the cells. In other words, currency data should NOT be entered as 'Rp40,179.00' as it will be seen as a text string, and it will not be possible to use the information in calculations or pivot tables.