| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you place a Zero at the beginning of a numbr (Ex. D.L. #).
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you place a Zero at the beginning of a numbr (Ex. D.L. #).
If the values are numeric, maybe you could just change the format of the cells.
Select the cell Format|Cells|Number tab (in xl2003) Custom category use a format like: 000000 to show 6 digits. (If your value is 5 digits long, you'll see a leading 0.) vrogers wrote: -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to show numbr in words like (100 = One Hundred ) | Excel Discussion (Misc queries) | |||
| How do i add " to the beginning of all cells | Excel Discussion (Misc queries) | |||
| add "0" to the beginning of each value | Excel Worksheet Functions | |||
| zero at the beginning of a telephone# | New Users to Excel | |||
| Zero at the beginning of a number | Excel Discussion (Misc queries) | |||
Hybrid Mode
