close

I need to put leading zero's in excel cells. Can somebody please help.

Thanks,
Vincenzo

Preformat the cell(s) as Text
Precede your data entry with an apostrophe: '000123
Or give the cell(s) a custom format of: 00000
(via format|cells|number tab|custom category--use as many zeros as you need)

Vincenzo wrote:
gt;
gt; I need to put leading zero's in excel cells. Can somebody please help.
gt;
gt; Thanks,
gt; Vincenzo

--

Dave Peterson

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

    software

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