View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scott
 
Posts: n/a
Default Formula to a number can you tell

In cell a1 I have a formula. At times whole numbers are entered in this cell
replacing the formula. In a seperate cell is it possible to distinguish if
there is a formula or number in cell a1 using another formula. I do not want
to track changes I just would liek to know what is in cell a1

Thanks
Scott