View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Chet is offline
external usenet poster
 
Posts: 88
Default Detecting a number versus text?

Does anyone know how to tell if a cell is a number when the value in
that cell is actually text? In other words if I have the character 3
in a cell and the cell is in the format of "text" how can I tell that
this is in fact a number in my code. I tried using the cint function
but I got an error message upon performing this function.

Thanks,
Chet