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

u did not say what to select select number then what?

"Mike H" wrote:

Hi,

First and most important tap the caps lock key to stop shouting and then try

Format|Cell|number and select number


Mike

"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 ?