| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Linear Mode
