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

[rmingle]

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

 

[Marcelo]

hi, you can format the cells as a text,

hope this helps
Regards from Brazil
Marcelo

"rmingle" escreveu:

 

[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