View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andreawilson5 Andreawilson5 is offline
external usenet poster
 
Posts: 1
Default Is there a way to view how a cell is currently formatted?

I am gettin the #VALUE! error in one of my formulas and one of the possble
reasons is that numbers may be formatted as text. The workbook I am working
in is protected so I cannot chang the formatting of the cells. I just need to
see if that is the problem so I can see what action needs to be taken.