Cell formatting issue

S

sissyshame

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!
 
D

Doug Kanter

sissyshame said:
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!
Click to expand...

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.
 
R

Ron Rosenfeld

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!
Click to expand...

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
 
D

Duke Carey

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.
 
Top