I have a worksheet that will have data entered into it that will sometimes
contain an "E" (e.g. 727E+10). The problem is, EXCEL essentially reads this
as 727*10^10. I know that by formatting the cell to text will fix this.
However, some of the data that is entered will just be numbers (without any
text) and I have formulas that calculate differently based upon whether the
input is a number or text. So, I can't really change all the cells to text
because it will throw off my formulas and I don't want the people entering
the data to have to go through and individually change all the cells
containing "E" to text. Is there a setting I can change that will stop Excel
from reading and E as something to the tenth power?

Thanks.