How do I display an insignificant 0 at the beginning of a number

G

Guest

I am trying to display a number (eg 123456) with a 0 (zero) at the beginning
(eg 0123456). Since excel does not display an insignificant zero by default,
can anyone tell me how I can do this and apply the rule to a list of cells
that already contain a 7 digit number without having to re-enter the
information.
 
J

Jason Morin

Go to Format > Cells > Number tab and click "Custom".
Under "Type" put: 0000000

HTH
Jason
Atlanta, GA
 
G

Guest

hi,
you can pre-format the cell to text.
or create a custom format by going to format>cell>number
tab>custom and enter 0000000. but this will only change
how the number looks. it will appear in the cell as
0123456 but in the formula bar it will appear as 123456.
if you copy and paste the number into another workbook or
application it will apear 123456.
 

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

display zero values at the beginning of a number. 2
Zero at the beginning of a number 4
PC often crashes, at the beginning or after pixels appear 3
How to display a number beginning with zero 3
How do I add (') at the beginning and end of a series of numbers? 1
How do i prevent the 000's in the beginning of an entry from dropp 7
How do I get Excell to recognise 0 at the beginning of a number? 3
How add a digit to front of number in each cell in excexl column 1

Top