Excel Help

[fiveteamer]

How to allow ZERO'S "0" at the beginning of a number?

eg. 010509 turns into 10509

[wtt0315]

at the top put in ' in front of it
if you put the ' in front of anything it shows what you are typing so in the top box put in '010509

[Regul8er]

Right click the cell, or range of cells.
Click format cells.
Make sure your in the "number tab" and change from Genereal to Text

[Willie Bee]

Only way I know 5T is to format that cell for 'TEXT.'

[MartinBlank]

This is the way I do it.

There may be an easier way.

On your Excel Page....place your cursor in the upper left corner, between the "A" and the "1".

That function highlights the entire page.

Right click.

Select "Format Cells"

From the menu select "text"

Click OK.

That will allow you enter 09093993 without it defaulting to 9093993.

[wtt0315]

easiest way is still just put the ' in it

[fiveteamer]

thank You Kindly.

[Ganchrow]

1. Highlight the cells for which you want this custom formatting.
2. Go to Format => Cells... and then click the Number tab.
3. Select "Custom" from the "Category" box and then in the "Type" box enter "000000".
4. Click OK.

Now if you were to enter 12345 into a cell it would display as "012345", while 123 would display as "000123".

The other two methods above (formatting the cell as text or prepending a single quote) above would all cause Excel to treat the cell contents as text, making it unable to use the contents in mathematical operations. If this isn't of importance to you then go for it.

Is this what you're looking for?

[MonkeyF0cker]

easiest way is still just put the ' in it

Not if you have to do it repetitively...

[Willie Bee]

1. Highlight the cells for which you want this custom formatting.
2. Go to Format => Cells... and then click the Number tab.
3. Select "Custom" from the "Category" box and then in the "Type" box enter "000000".
4. Click OK.

I thought about that as well, Ganch, but wasn't sure he wanted them all to be 6-digits