Help me figure this out

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

I have tried to format it as a number and text... text puts it into Scientific notation and the number format is still changing the last number back to zero... Is there some place else I may have formated it to round up or down?

[Paul]

You can't enter a number larger than 15 digits in a cell unless you format the cell as TEXT (Format-->Cells...) BEFORE you enter the data. Another option would be to precede the long number with an apostrophe (') when entering it, like so:

'123455432112345554321

Once you exit the cell, the apostrophe will hide itself.

The 15-digit problem is a limitation of Excel in handling more than 15 digits of precision, and you're not the first to stumble across it.

NOTE: Please change your subject from "Help me figure this out" to something short but descriptive of your actual problem, like "Long numbers keep rounding off"

[mudraker]

BamBamExcel


Please read the forum Rules - see links below

This is a duplicate post & has poor a poor title

If a reply had not already been posted I would have deleted this thread