View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default numbers appear different after hitting enter


If the cell is formatted as general a number with more than 11 digits will
be displayed in the scientific format.
You can show a max of 15 digits but anything above 11 must be formatted as
number or custom not general.
--
Greetings from New Zealand

"cb" wrote in message
...
TYPING NUMBERS IN A CELL
WHEN I GO TO ANOTHER CELL THE NUMBERS APPEAR DIFFERENT AND WITH + SIGNS
LIKE
THIS 5.63209E+11
HOW DO I CLEAR IT ?