why does a subtract of 1- 5.6e59 give 1 instead of correct result

[joer]

is there away to get accurate results using scientific notation in
subtracting for probability loss calculations using 2007 excel.

 

[Gary''s Student]

=1-5.6E+59
show display:
-5.6E+59
and not one