Formatted numbers problem - How to get rid of those "1.00043E+11"

[Dave K]

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.

 

[Dave Peterson]

How about using Number in the
format|cells|Number tab|number category
Show the 1000's separator and as many decimal places as you want.

You may have to widen the column, too.

 

[one third]

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.

I would try fomatting a cell with the number 0 (zero) as you want it,
then copy it and 'paste-special-operation-add' it to the cells you are
trying to update.

I hope that works for you.