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 ***
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 ***