Is it a formula or a number in cell

[scooper]

Hi,
I need to check if a cell has a formula or a simple number in it.
Any ideas?
scooper

 

[Guest]

Select the cell and see what appears in the formula bar.

Alternatively, select the entire worksheet, go to Edit--Go
to--Special--Objects and see if the cell is highlighted.

Finally, you could create a UDF, getformula, which would allow you to check
any cell for its formula: http://www.mvps.org/dmcritchie/excel/formula.htm

 

[Guest]

Try this:

Ctrl+`