Lengthy Account Numbers

  • Thread starter Thread starter Louise
  • Start date Start date
L

Louise

Hi,

I am setting up an excel spread sheet with account numbers for
mastercards, visas, bank accounts, and whenever the accounts are over 12
numbers in length, the spreadsheet is automatically changing the last
few digits of the account number to zeros and is also taking off any
zeros at the start of the account numbers. I have made sure that the
format for the cell is number with no decimal points, but I cannot enter
any account numbers over 12 digits where the account number does not get
changed. The version of excel I am using is excel 2000.

Thanks for your help.

Louise

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
Hi
Excel only supports 15 significant digits for numbers (so credit cards
can't be stored as numbers). As you won't calculate with these numbers,
store them as text: To do this:
- format the cells prior to the data entry as 'Text'
- or precede the entry with an apostophe. e.g.: '1234567890123456
 
Back
Top