View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CB CB is offline
external usenet poster
 
Posts: 97
Default NUMBERS SHOWING DIFFERENT AFTER TYPE

typing like 12 number in a cell did what you said that still not working

"Gary''s Student" wrote:

For noremal numbers, medium & small, make sure the format is not scientific:

Format Cells... Number General

For BIG NUMBERS like: 1234567890123

Excel will default to scientific unless you format as Custom 0000000000000

--
Gary''s Student - gsnu200776


"cb" wrote:

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 ?