Knowledge Base

XL7: Format Phone Number Does Not Retain Leading Zeros

PSS ID Number: 133200

Article Last Modified on 10/22/2000


The information in this article applies to:


This article was previously published under Q133200

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.

Keywords: KB133200
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch