Cell Formating Excel

  • Thread starter Thread starter JonathanHall
  • Start date Start date
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!
 
That is how Excel works.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Stop XL from changing format? 1
Cell formatting issue 8
How do I stop Excel 2007 from using scientific notation? 2
Excel 2007 bug? Merged cells must be formatted as scientific 2
Text in Text-formatted cells changes to ### after the 255th charac 2
Format Excel cells for "all caps", with Office 07? 4
CSV text data altered on file open 4

Back
Top