COBOLforever
asked on
excel converts formula to exponential notation
Hi all,
I have a column that contains a formula. I have formatted the column general. I type in the formula and copy it down the column. Some of the clls calc fine, others show as exponential notation. There is nothing special that I can see about the cells being used in the calculation. It seems random but I am sure it's not. What's up? I have attached sheet. Check out rows starting 294. Thanks. QCC01-T2-Process-20110914v3.xlsx
I have a column that contains a formula. I have formatted the column general. I type in the formula and copy it down the column. Some of the clls calc fine, others show as exponential notation. There is nothing special that I can see about the cells being used in the calculation. It seems random but I am sure it's not. What's up? I have attached sheet. Check out rows starting 294. Thanks. QCC01-T2-Process-20110914v3.xlsx
ASKER
But I cannot format as number because the cells are formulas, right?
ASKER
interesting - I did as I was told ... it works. It appears that it only happens when the formula equates to 0.00?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
excellent - - thanks for the great clarification and explanation.
the value in cell I294 is
-0.00000000000011368683772
The General format will display this in exponential notation. To change that, format the cells as Number instead.
cheers, teylyn