| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NUMBERS SHOWING DIFFERENT AFTER TYPE
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 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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 ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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) cb wrote: 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 ? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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. -- David Biddulph "cb" wrote in message ... 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 ? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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 ? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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 ? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
NUMBERS SHOWING DIFFERENT AFTER TYPE
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 -- Gary''s Student - gsnu200776 "cb" wrote: 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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My large numbers are showing up as a formula | Excel Discussion (Misc queries) | |||
| showing only positive numbers | Excel Discussion (Misc queries) | |||
| Dates showing are not what I type | New Users to Excel | |||
| Area that duplicate showing what I type in a cell is missing. | Excel Discussion (Misc queries) | |||
| showing negative numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
