| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formating Excel
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! -- Jonathan Hall The Atkins Group |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Formating Excel
That is how Excel works.
Format the cells as Text and Excel will not try to "help" you by changing your data -- Gary''s Student - gsnu200807 "JonathanHall" wrote: 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! -- Jonathan Hall The Atkins Group |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Changes cell formating after file is saved | Excel Discussion (Misc queries) | |||
| 2007 Excel conditional formating, reference cell containing specif | Excel Discussion (Misc queries) | |||
| FORMATING WITHIN CELL | Excel Worksheet Functions | |||
| Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
| cell formating | Excel Worksheet Functions | |||
Linear Mode
