How to Fix Incorrect Indonesian Rupiah Currency Formatting in Excel
Question details
The user needs to properly format numeric values as Indonesian Rupiah (Rp) and resolve formatting discrepancies across different computer locales.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Applying currency or custom number formatting to financial data to correctly display Indonesian Rupiah symbols and separators.
- Observed behavior
- Rupiah values display incorrectly due to mismatched regional settings, text-formatted numbers, or incorrect custom decimal and thousands separators.
Verify that your financial data is stored as actual numeric values and not text strings, as spreadsheet programs cannot apply currency formatting to text.
Apply a Custom Number Format for Indonesian Rupiah
Use the Custom Format feature to force the display of the "Rp" symbol and correct separators regardless of your computer's regional default settings.
By defining a specific custom number format, you ensure that the Indonesian Rupiah symbol appears consistently even if the workbook is opened on a computer with a different system locale.
Highlight the cells containing the financial values you want to format.
Right-click the selected cells and choose 'Format Cells' from the context menu, or press Ctrl+1 on your keyboard.
Navigate to the 'Number' tab and select 'Custom' from the category list. In the 'Type' box, enter the custom format code: Rp #,##0
Click 'OK' to apply the format. Test the formatting by typing 1000 or 60000 into a cell to ensure the separators and Rp prefix appear correctly.

Adjust System Regional Settings
Align your computer's region with Indonesia so the software automatically applies the correct decimal (comma) and thousands (period) separators.
Convert Text-Formatted Numbers to Numeric Values
Fix formatting issues caused by data being imported or saved as text rather than numerical data.
Format Global Currencies Easily with WPS Spreadsheet
WPS Spreadsheet provides a seamless, built-in way to apply global currency formats—including Indonesian Rupiah (IDR)—without requiring complex system setting changes or custom code memorization.
- 1. Open Your File in WPS: Launch WPS Spreadsheet and open your financial workbook.
- 2. Select Target Cells: Highlight the cells containing the numbers you wish to format as Rupiah.
- 3. Access Formatting Options: Right-click the selection and choose 'Format Cells', or press Ctrl+1.
- 4. Select Currency Type: Under the 'Number' tab, choose 'Currency' or 'Accounting'. Click the 'Symbol' drop-down and select 'Rp Indonesian Rupiah'.
- 5. Apply Formatting: Adjust your preferred decimal places and click 'OK' to instantly apply the correct formatting.

Frequently Asked Questions
Why does my Rupiah format show a comma instead of a period for thousands?
Spreadsheet software relies on your operating system's regional settings to determine separator symbols. In US formatting, a comma is used for thousands, while Indonesian formatting uses a period. You can change this globally in your Windows Region settings, or adjust the separator behavior in your spreadsheet's advanced options.
Can I use 'IDR' instead of 'Rp' for my currency format?
Yes. If you prefer the international currency code over the local symbol, you can use a custom format. Open the Format Cells dialog, select Custom, and enter the code "IDR "#,##0 into the Type box.
Why is the Rp symbol placed far to the left of the number?
This alignment occurs when you apply the 'Accounting' format rather than the 'Currency' format. The Accounting format always aligns currency symbols to the left edge of the cell. To keep the symbol immediately next to the number, switch to 'Currency' format or use the custom format code Rp #,##0.
Why doesn't the formatting change when I apply the custom code?
If the formatting does not update, your data is likely stored as text. Spreadsheet programs cannot apply number or currency formatting to text strings. You must convert the text to numbers first by clicking the warning icon next to the cell and selecting 'Convert to Number'.




