 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008NUMBERS 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 ? Hi, First and most important tap the caps lock key to stop shouting and then try Format|Cell|number and select number Mike > 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 ? u did not say what to select select number then what? > Hi, > [quoted text clipped - 8 lines] > > THIS 5.63209E+11 > > HOW DO I CLEAR IT ? 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) > u did not say what to select select number then what? > [quoted text clipped - 10 lines] > > > THIS 5.63209E+11 > > > HOW DO I CLEAR IT ?  SignatureDave Peterson 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. SignatureDavid Biddulph >u did not say what to select select number then what? > [quoted text clipped - 12 lines] >> > THIS 5.63209E+11 >> > HOW DO I CLEAR IT ? 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 SignatureGary''s Student - gsnu200776 > 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 ? NOT WORKING > For noremal numbers, medium & small, make sure the format is not scientific: > [quoted text clipped - 8 lines] > > THIS 5.63209E+11 > > HOW DO I CLEAR IT ? typing like 12 number in a cell did what you said that still not working > For noremal numbers, medium & small, make sure the format is not scientific: > [quoted text clipped - 8 lines] > > THIS 5.63209E+11 > > HOW DO I CLEAR IT ? 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 SignatureGary''s Student - gsnu200776 > typing like 12 number in a cell did what you said that still not working > [quoted text clipped - 10 lines] > > > THIS 5.63209E+11 > > > HOW DO I CLEAR IT ? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.