Big number error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pcor - 02 Nov 2007 21:04 GMT

6018971032413880
That number is a big number but why is it if I try to chage the last zero to
a 3 while in Excel, the zero always comes back as soon as I hit ENTER

Thanks

Reply to this Message

Peo Sjoblom - 02 Nov 2007 21:34 GMT

Look up specifications in Help and you'll find it's not an error, Excel have
15 digits of precision,
everything beyond that will be truncated. Assuming you have credit card
numbers or account numbers just precede any entry with an apostrophe or
pre-format the cells(s) as text

Signature

Regards,

Peo Sjoblom

> 6018971032413880
> That number is a big number but why is it if I try to chage the last zero
> to
> a 3 while in Excel, the zero always comes back as soon as I hit ENTER
>
> Thanks

Reply to this Message

pcor - 05 Nov 2007 03:53 GMT

Thanks for that important info

> Look up specifications in Help and you'll find it's not an error, Excel have
> 15 digits of precision,
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Rate this thread: