Add a Leading Zero or +27 Country Code to Phone Numbers in Excel
Question details
Display South African cellphone numbers with a leading zero or the +27 country code without changing their underlying numeric values.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains South African cellphone numbers stored as numbers, and the user wants to show them in local or international form.
- Observed behavior
- The numbers should display with a leading zero or +27 prefix while retaining their stored numeric values.
Check that the selected cells contain numeric values representing the nine digits after the South African trunk zero. For example, 821234567 can represent the local number 0821234567; custom number formats will not change text values.
Use a Custom Number Format for South African Cellphone Numbers
Choose a custom format to show either a local leading zero or an international +27 prefix without changing the stored number.
In Excel, select the cells containing the numeric cellphone numbers.
Right-click the selection, choose Format Cells, and open the Number tab.
Select Custom. In the Type box, enter 0000000000 for local display or "+27"000000000 for international display, then click OK.
Verify a sample cell: the stored value 821234567 should display as 0821234567 or +27821234567, depending on the format you chose.

Display South African Phone Numbers in WPS Spreadsheet
Use a custom number format in WPS Spreadsheet to show a leading zero or +27 prefix while keeping the numeric value unchanged.
- 1. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
- 2. Select the phone numbers: Select the cells containing the nine-digit numeric values after the local trunk zero.
- 3. Apply a custom format: Right-click the selection, choose Format Cells, and select Custom. Enter 0000000000 for local display or "+27"000000000 for international display, then confirm.
- 4. Verify a sample: Check that 821234567 displays as 0821234567 or +27821234567, depending on the format selected.

Frequently Asked Questions
Does the +27 format remove the local leading zero?
For a numeric value such as 821234567, Excel has not stored the leading zero. The custom format "+27"000000000 displays +27821234567 by adding the prefix to the nine stored digits.
Why does the custom format not change my phone numbers?
The cells may contain text rather than numbers. Custom number formats do not change text values. Check a cell in the formula bar and confirm how the data is stored before applying the format.
Will the prefix appear in the formula bar?
No. A custom format changes the cell's display, not its underlying value. Select the cell to see the stored value in the formula bar.
Can I use the +27 format if the stored number already begins with 27?
No. The format adds a visible +27 prefix, so applying it to a value that already includes 27 would duplicate the country code. Check the stored values before formatting.




