NUMBERS NOT TYPING CORRECTLY

  • Thread starter Thread starter cb
  • Start date Start date
C

cb

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS
 
Elect to format the Cell to display in the desired manner.

Right click on the cell, and pick Format cell
 
Have you tried formatting to Special>Zip Code?


Gord Dibben MS Excel MVP
 
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 Typed text appears in wrong cell 0
tiny discrepancies in fixed-point numbers 3
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Include a value from one cell within text of another cell. 2
Last Modified By in a cell by user 3
How can I keep a zero at the beginning of a mobile number? 3
Entering 'GTi' but I get 'Gti' ! 2

Back
Top