Why does my formula keep returning a zero?

[sccrsurfer]

Im trying to do a simple CAGR formula and for some reason I keep getting a 0, when I know it's wrong. Is there something wrong with my formula? The two cell references are whole numbers and both are positive. When I hit enter, it comes up as a zero. Note: I even tried to enter it as an array ctrl+shift+enter, and I still got a zero. Please help! Thanks!

=(('Key Financials'!B3/'Key Financials'!D3)^(1/2))-1

 

[Joe4]

That did it! Thanks. To think it was a decimal problem. Excel is one evil mistress. Thanks guys!

Excel is a "saint" compared to Microsoft Word.
Excel usually does what you tell it to, unlike Word, that too often tries to "guess" what you want to do.