I have a list of account numbers in a column and in every cell as I type
excell changes the last digit to a 0. I have checked formatting and have
changed to text, number, etc...nothing is working!

"sissyshame" wrote in message
...
I have a list of account numbers in a column and in every cell as I type
excell changes the last digit to a 0. I have checked formatting and have
changed to text, number, etc...nothing is working!

Sometimes, if a cell already contains data, changing it to text doesn't
work. By way of experiment, open a new sheet, format some cells as text
before typing, and then see if your number appear correctly after entering
them.

On Fri, 10 Feb 2006 11:58:33 -0800, "sissyshame"
wrote:

I have a list of account numbers in a column and in every cell as I type
excell changes the last digit to a 0. I have checked formatting and have
changed to text, number, etc...nothing is working!

Probably your numbers are 16+ digits.

You must change the formatting to TEXT *before* you enter the number.

OR prefix the number with a single quote.


--ron

Sounds as though your account # is 16 or more characters and Excel can only
handle a 15 digit number.

To get around this, make sure you format the cell as text OR type an
apostrophe before the account number. That way Excel will treat it as text
and will accept the whole account number.

If you've already entered the # and then change the formatting to text, it
won't 'fix' existing problems; you'll have to re-enter the #s as text.


"sissyshame" wrote:

I have a list of account numbers in a column and in every cell as I type
excell changes the last digit to a 0. I have checked formatting and have
changed to text, number, etc...nothing is working!