Translations:Basic Excel/104/en
In the example below, the data in cells D2:D3 were entered as 'Rp40,179.00'. In contrast, the data in cells E2:E3 were entered as 40179, and currency formatting applied so that the display appears identical to D2:D3 cells. However, because Excel interprets the data in cells D3:D3 as text, the formula in cell D4 does not work. The same formula (in cell E4) applied to cells E2 and E3 performs the calculation without problems.