Removal of the '-' means that Excel now considers this to be a numeric,
for which it holds only the first 15 digits.
Setting the cell to TEXT format before your edit should help.
--
Gazzr Wrote:
Hi All,
My spreadsheet contains bank account numbers that contain "-" and
spaces. To get rid of these characters I use Edit Find Replace.
When I do this the last digit of the 16 digit number changes to a zero
rather than show the correct number. The first 15 digits of the account
number are fine. Its just the last digit that seems to be affected.
Any ideas?
Regards
Garry
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=530795