![]() |
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 |
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 |
All times are GMT +1. The time now is 06:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com