I use client ID #s. Some begin with 0. 0 needs to show

R

rmingle

I am creating a client sheet. Some of the Client ID #s begin with Zero. How
can I get the Zero to show?
 
M

Marcelo

hi, you can format the cells as a text,

hope this helps
Regards from Brazil
Marcelo

"rmingle" escreveu:
 
H

hans bal(nl)

You can also use a custom format:

Suppose you ID numbers have 7 character including the leading 0 then do this:

Select the cell(s)
Press Ctrl-1
In the numbers tab select custom.
In the box "type" enter 7 zero's

HTH
 
Top