Formatting Issues

Add a Leading Zero or +27 Country Code to Phone Numbers in Excel

Bushra ParveenBushra Parveen Nov 18, 2026 870 views

Question details

Display South African cellphone numbers with a leading zero or the +27 country code without changing their underlying numeric values.

Add a Leading Zero or +27 Country Code to Phone Numbers in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the numbers

In Excel, select the cells containing the numeric cellphone numbers.

2
Open Format Cells

Right-click the selection, choose Format Cells, and open the Number tab.

3
Enter a custom format

Select Custom. In the Type box, enter 0000000000 for local display or "+27"000000000 for international display, then click OK.

4
Check the display

Verify a sample cell: the stored value 821234567 should display as 0821234567 or +27821234567, depending on the format you chose.

Use a Custom Number Format for South African Cellphone Numbers
Formatting affects display only: The leading zero or +27 prefix is not added to the stored value. Exporting or copying the data to another application may not preserve the displayed format.
Format phone numbers in WPS

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. 1. Open the workbook: Open WPS Spreadsheet and use Open to select your workbook.
  2. 2. Select the phone numbers: Select the cells containing the nine-digit numeric values after the local trunk zero.
  3. 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. 4. Verify a sample: Check that 821234567 displays as 0821234567 or +27821234567, depending on the format selected.
Display local or international cellphone number formatsKeep the underlying numeric values unchangedOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formatting controls
microsoft office alternative - wps office

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.