Originally Posted by Colin Legg

Hi,

To enter exponentials in Excel you need to use the ^ symbol.

I've got better news for you though: Excel 2007 has a built-in worksheet function to calculate the CAGR. The function is called XIRR(). You can find more information about it in the Excel helpfile and there's an example here:

http://office.microsoft.com/en-us/ex...001122506.aspx


Hope that helps...