Excel Chart Formula Displayed in Scientific Format

[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.

 

[Bernard Liengme]

See www.stfx.ca/people/bliengme/ExcelTips on the use of LINEST to get the
values into cells - then you can have what ever format you need and there is
no need to copy the values.

 

[Jon Peltier]

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