Excel spreadsheet

[Guest]

I am trying to set up a spreadsheet with my credit card info. When I type in
accout numbers such as:
1111222233331111 it comes out:
1111222233331110

A zero always appears where a one should be.
Why is this happening? What can I do to get it to do the correct number?

 

[Simon Murphy]

Excel cannot hold a 16 digit number accurately - It misses the last digit as
you have seen
easiest solution is to store them as text (put a ' apostrophe in front) you
wont be doing arithmetic with them anyway will you?

cheers
Simon

 

[Guest]

It works!!! Thanks for the help. I've been going nuts trying to figure this
out.

 

[Simon Murphy]

Many of us have!

It works!!! Thanks for the help. I've been going nuts trying to figure
this
out.