I use client ID #s. Some begin with 0. 0 needs to show
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
"Marcelo" wrote:
hi, you can format the cells as a text,
hope this helps
Regards from Brazil
Marcelo
"rmingle" escreveu:
I am creating a client sheet. Some of the Client ID #s begin with Zero. How
can I get the Zero to show?
|