Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top