| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I use client ID #s. Some begin with 0. 0 needs to show
I am creating a client sheet. Some of the Client ID #s begin with Zero. How
can I get the Zero to show? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
I use client ID #s. Some begin with 0. 0 needs to show
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show data used and percent label | Charts and Charting in Excel | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Show values from other sheet | Excel Worksheet Functions | |||
| with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) | |||
| How to make a cell show totals | Excel Discussion (Misc queries) | |||
Linear Mode
