NUMBERS SHOWING DIFFERENT AFTER TYPE

[cb]

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 ?

 

[Mike H]

Hi,

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

Format|Cell|number and select number


Mike

 

[Gary''s Student]

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

 

[cb]

NOT WORKING

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

 

[cb]

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

 

[cb]

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

 

[Gary''s Student]

If you type 12 and the cell shows:
1.20E+01
Then the display is scientific. To fix, select the cell and pull-down:
Format > Cells... > Number > General

 

[Dave Peterson]

Click on the the Format option in the top toolbar (in xl2003 and below)
Then click on Cell
Then click on the Number tab
Choose Number from the category on the left hand side.
Choose details the way you like (decimals and 1000's separator)

 

[David Biddulph]

Number, and zero decimal places, if that's what you want, and make sure that
your cell is wide enough to take the number or else it will change back to
scientific.