View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
hans bal(nl)
 
Posts: n/a
Default 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?