close

How can I show leading zeroes in zip codes in an Excel spreadsheet? I have
clicked the Tools-Options-View-Show Zeroes but the leading zeroes do not
appear.

Hi,

Select the column (or row) containing the zip codes --gt; quot;Formatquot; --gt; quot;Cellsquot;
--gt; click on quot;Number Tabquot; and quot;Specialquot; for quot;categoryquot; --gt; quot;Zip Codequot; for
quot;Typequot; --gt; quot;OKquot;

Regards,
B. R. Ramachandran

quot;bookloverquot; wrote:

gt; How can I show leading zeroes in zip codes in an Excel spreadsheet? I have
gt; clicked the Tools-Options-View-Show Zeroes but the leading zeroes do not
gt; appear.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄