Error indicator in cell A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error Button image button appears. Click the arrow next to the button for a list of options.
I have some cell that will not chg formatting... unless I use the little arrow off to the left of the cells.
Can I force the "Convert to Number with a macro on the column of where the active cell is?