Number not showing correctly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Excel Vba to change displayed year automatically. 14
Can you "freeze" a chart?? 2
Naming ranges on multiple worksheets 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Canon IP 6600D Photo Printer 2
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Create a yes no message on a command button on click 0
Excel Sequential Numbering System 0

Back
Top