| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check for cell with numeric value
I have a function to append/alter a cell depending on it's contents Is there an easy way to determine cell has a numeric value rather than text ....cell.Value 0 returns true even if cell has Text in it -- Steve (3) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check for cell with numeric value
if isnumeric(cell.value) then
-- Regards, Tom Ogilvy "SteveW" wrote: I have a function to append/alter a cell depending on it's contents Is there an easy way to determine cell has a numeric value rather than text ....cell.Value 0 returns true even if cell has Text in it -- Steve (3) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check for cell with numeric value
Works in my function perfectly
Thanks Steve On Wed, 07 Feb 2007 16:37:01 -0000, Tom Ogilvy wrote: if isnumeric(cell.value) then |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TO DELETE ONLY NUMERIC VALUES IN A CHARACTER AND NUMERIC CELL IN | Excel Discussion (Misc queries) | |||
| How do I copy numeric section of cell from alpha-numeric cell | Excel Worksheet Functions | |||
| check is input textboxes is numeric on userform | Excel Programming | |||
| How do i check if something non numeric is in a range & return'Y' | Excel Worksheet Functions | |||
| function to check numeric value | Excel Worksheet Functions | |||
Linear Mode
