Is there a way to view how a cell is currently formatted?
Numbers align right and text aligns left in worksheet cells.
If you have a number on the left side of a cell and the toolbar alignment
button is not activated then the number is probably being treated as text.
--
Jim Cone
Portland, Oregon USA
"Andreawilson5"
wrote in message
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.
|