EXCEL 2007 reading E as power of ten
You can either enter that data with a leading apostrophe, '727E+10 or if you
format the column as text, you should be able to change the other formulae
to accommodate this. Give an example and we'll show you how, as well as an
example where you do different things depending upon whether it is text or
not.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"DoubleZ" wrote in message
...
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.
|