MC -
Several possibilites:
(1) Select the equation, and then Format it. Method depends on Excel
version, which you didn't specify.
(2) For a linear trendline, use the INTERCEPT and SLOPE worksheet functions
(or array-entered LINEST, especially if you want diagnostics).
(3) Or, for linear forecasts, use the array-entered TREND worksheet
function.
- Mike
http://www.MikeMiddleton.com
"MC" wrote in message
...
Hello Everyone -
When use a series of data and create a chart - then from that create a
treadline to forecast future values - sometimes the formula Excel provides
(used to forecast the future values) is, im guessing, to big or too long and
Excel will place an E next to a number.
Here is an example: y = 762870x + 5E+06
How can I see the equation in its entirety so I can use it?
Thanks!