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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a client sheet. Some of the Client ID #s begin with Zero. How
can I get the Zero to show?
 
hi, you can format the cells as a text,

hope this helps
Regards from Brazil
Marcelo

"rmingle" escreveu:
 
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
 
Back
Top