MS Excel question?

[stephen4785]

Im trying to create a document and I need to enter numbers in a vertical column. The number are all 3 digit number and alot of them start with 0.Every time I enter in 041 and go to the next box the number changes from 041 to just 41. I have to have the zero's in front of the number. Anyone know how to trun off the auto correct feature?

[That_Is_My_El_Camino]

Select the column.
Go to Format -> Cells...
Select the Number tab.
Click Custom in the Category list.
Type 000 into the Type text box.
Click OK.

[barronj]

Select the column you're working with, right click and choose format cells. Choose "text" to leave the information (numbers in this case) exactly as you've entered it.

[flied_lice]

Im trying to create a document and I need to enter numbers in a vertical column. The number are all 3 digit number and alot of them start with 0.Every time I enter in 041 and go to the next box the number changes from 041 to just 41. I have to have the zero's in front of the number. Anyone know how to trun off the auto correct feature?

excel thinks you are entering integers, but what you really want to do is enter them as text. thats the only way to get leading zeros in a field where you are entering numbers

try this, enter an apostrophe before entering your number with the leading zeros. it should look like this:

'041

excel should interpret it correctly now. PM me if you have questions.

[stephen4785]

cool. Thanks a lot guys