Early alternative to ISFORMULA() function 1

[Denial]

I am looking for a way to detect whether an Excel cell contains a numerical value or a formula that returns a numerical value.[ ] In later versions of Excel the ISFORMULA() function would do exactly what I need, but this function is not offered in the version I am using (2010).[ ] I would prefer a solution that does not involve VBA, but will use VBA if necessary.

[sub][ ]—————————————————————————————————[/sub]
[sup]Engineering mathematician / analyst.[ ] See my profile for more details.[/sup]

 

[3DDave]

In a compiled language the assignment to PI is to create a numeric constant; the other is a pointer to variable.

The original goal seems to be to detect if formulas have been pasted or numeric constant; simply turning off recalc eliminates the need to do the copy/paste and to detect it was done correctly.

It's a shame Excel doesn't have a method to lock formula results separately from locking formulas.