Help with number format in cells

[Pandab2002]

I am inputing account numbers in a cell. The cell is formatted for numbers with no decimal places. When I type in a number like this 1234567891115 it changes the last digit to a 0. Any suggestions?

 

[yogia]

Hi Pandab2002:

I am inputing account numbers in a cell. The cell is formatted for numbers with no decimal places. When I type in a number like this 1234567891115 it changes the last digit to a 0. Any suggestions?

You should be able to put a number with upto 15 digits without a problem, every digit after the 15th place will be 0.

If you do have entries with more than 15 characters, you may have to resort to TEXT.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[SkipVought]

Hi,

faq68-6659.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}