When copying some numbers from our intranet or from a .txt
file, Excel often changes the end of the numbers or
totally changes the formatting of the numbers.  When I try
to reformat the cells, most of the time it gives me most
of the correct numbers but will change the last number to
0 instead of using the correct number.  Strange thing is
that on some numbers that might be 14 or 15 digits long,
the reformatting works; but on numbers that are 16 digits
long, it doesn't work.  Does anyone know of any option in
Excel that I need to change that will help?