Numbers won't enter

[BamBamExcel]

I have Excel 2003 - when I enter an account number in a cell the final number switches to a 0 ie I enter 345555 and it switches to 345550... I am trying to put together a spread sheet with all my credit card etc accounts and numbers on it. In the Cell under the account name I entered the account number... and for some reason the last number only changes to 0 no matter what I enter or try to renter.... Please help this is driving me crazy!

[Trebor76]

Hi there,

Sounds strange . I'd say it's do with the formatting of the cell. To check it do the following 3 steps:

1. Select a cell in question
2. From the Format menu select Cells
3. Select the Number tab from the Format Cells dialog box

Change the format from the Category list to suit.

HTH

Robert

[Paul]

Bam, don't post duplicates on the boards, please.

See my explanation, as there is a known limitation of Excel when entering numbers (e.g. credit card #'s) greater than 15-digits in precision.

http://www.excelforum.com/showthread.php?t=593582

From Microsoft:

http://support.microsoft.com/kb/78113