Excel cannot handle "numbers" that large...Try this

Select the cells that will contain account numbers
FormatCellsNumber tab
Category: Text
Click the [OK] button

That will change the format to treat every value as text.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dan12" wrote:

I have a worksheet that has one column that has account numbers. If I enter
16 or more digits the last numbers change to a 0. I have set, cell format to
numbers with no decimals.