- Feb 14, 2005
I have a excel download from a database. When looking at a cell (example D10) the only thing visible is the following character *; however, when i click into the cell i can see a number for example 1,124. Can someone please help me write a formula in column E that will look in to column D and writing a formula that identifies that it is a non numeric cell. I have tried a IF statement it will not work since when you click on a cell a number appears. The * is only visible when clicking away from the cell.