Number not showing correctly

N

Nawas

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
 
R

Rod

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top