When I open reports in excel, I often see numbers that read 1.00043E
+11, apparently indicating that there is a number format problem.

When I change the cell format (to text or number), I am usually able
to see the full value in the cell.  However, I must first physically
enter each cell (i.e., selecting the cell, and then double clicking,
and then pressing enter) in order to accomplish this effect of seeing
the full value.

Is there a way to get around this?

Thanks for any suggestions.