Excel Chart Formula Displayed in Scientific Format

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

For some reason, the when I insert a trend line into a
graph, the formula comes up with one part of it in
scientific format (y = 2750.2x2 - 64597x + 2E+06). I konw
the last expression in the formula is $2,000,000 but this
is rounded- and I need to know what the exact amount is.
I have tried extending the formula box, but that doesn't
work. Can anyone help me? Thanks in advance.
 
To get the format in the formula, though, you can double click it, then
on the Number tab, select Scientific, and choose an appropriate number
of decimal places.

- Jon
 
Back
Top