XL7: Format Phone Number Does Not Retain Leading Zeros

ID: Q133200

7.00 WINDOWS kbusage

The information in this article applies to:

• Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel version 7.0, if you format a phone number that contains leading zeros, the leading zeros will be truncated.

MORE INFORMATION

This behavior is by design in the English (US) version of Microsoft Excel.

KBCategory: kbusage KBSubcategory:

Additional reference words: 7.00

Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997