How can you place a Zero at the beginning of a numbr (Ex. D.L. #).

D

Dave Peterson

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I keep a zero at the beginning of a mobile number? 4
How do I remove spaces at the beginning of cells? 3
how to get left side zeros to show i.e. 00045 0
VLOOKUP, a table with text and numerics 7
How do i prevent the 000's in the beginning of an entry from dropp 7
Adding a zero to the front of numbers 5
display zero values at the beginning of a number. 2
how to paste values created by custom format? 9

Top