Is it a formula or a number in cell
 

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

Is it a formula or a number in cell
 

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
--
Brevity is the soul of wit.


"scooper" wrote:

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

Is it a formula or a number in cell
 

Try this:

Ctrl+`


"scooper" wrote:

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