Cell Formating Excel

J

JonathanHall

When I type in the following characters 18E-259 in a cell it automatically
changes the format from General to Scientific. When that happens the
characters that were input are changed by Excel to 1.8E-258.

Can someone tell me why? I have to insert a ' prior to the input characters
in order to be able to have my input show up. And then it is tagged as an
error. I am curious why Excel changes the format to Scientific based on those
characters and why I get an error that has to be ignored.

Thanks for your help!
 
G

Gary''s Student

That is how Excel works.

Format the cells as Text and Excel will not try to "help" you by changing
your data
 
Top