| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Number not showing correctly
Hi, I had tried to enter a 12digit number in a worksheet but after entering
it its not showing the coorrect number.Eg Iam trying to enter 857268578633 in the work sheet but after entering its showing 8.57269e+11 Why its happened Like this can you please explain me |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Number not showing correctly
the format of the cell is probably 'General' instead of number. When you
select number you can select the number of decimal places and/or the comma and negative number format if you like. If it then shows up as ###### or still has the scientific format appearance, you can widen the column. "Nawas" wrote: Hi, I had tried to enter a 12digit number in a worksheet but after entering it its not showing the coorrect number.Eg Iam trying to enter 857268578633 in the work sheet but after entering its showing 8.57269e+11 Why its happened Like this can you please explain me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
| Zero showing as a negative number | Excel Discussion (Misc queries) | |||
| Letters and 000s in front of actual number not sorting correctly | Excel Discussion (Misc queries) | |||
| Add-in correctly deleted in Excel but still showing up in MSIE ?????????? | Excel Discussion (Misc queries) | |||
| formula will not fill correctly due to odd number rows | Excel Worksheet Functions | |||
Linear Mode
