Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
numbers appear different after hitting enter
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.newusers
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
numbers appear different after hitting enter
Yes I am enterting more numbers than 11 so how do I change it People tell me
to click on format cells number and they dont say to do anything else. so if i choose custom what do i choose i am sending tracking numbers for shipping so i am not adding anything just to show these numbers "Bill Kuunders" wrote: 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 ? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
numbers appear different after hitting enter
If numbers you type do not exceed 15 digits, just pre-format the cells to
SpecialZipcode If more than 15 digits, type an apostrophe before entering the digits. Gord Dibben MS Excel MVP On Thu, 27 Mar 2008 14:56:01 -0700, cb wrote: Yes I am enterting more numbers than 11 so how do I change it People tell me to click on format cells number and they dont say to do anything else. so if i choose custom what do i choose i am sending tracking numbers for shipping so i am not adding anything just to show these numbers "Bill Kuunders" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If I type in 3, I get .003 after hitting enter. All .xls files. | Excel Discussion (Misc queries) | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
How can I create a new line in a cell in Excel by hitting enter? | Excel Discussion (Misc queries) | |||
Cursor not to move when hitting the enter key | Excel Worksheet Functions | |||
how to insert row automatically after hitting enter at the end of. | Excel Worksheet Functions |