View Single Post
  #3   Report Post  
SUNIL S GAWDE \(INDIA\)
 
Posts: n/a
Default


-----Original Message-----
how do you add a zero in front of other numbers, I am

using item numbers and
most start with zero, just shows whole numbers when I

enter. example 095421
when I enter shows 95421. help.
.


You will have to custom format the cells in question
as "00" or "000" or "0000" etc depending on number of
leading Zeros you wish to put. The 1 will show as 01 or
001 or 0001 etc resp.
Select the cells in question. Go to Format-Cells-Number-
Custom. Then type 00 or 000 or 0000 etc in the Type: box
to the right side.
Hope this helps you. You can reach me at
for more assistance.