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
AFTER I PRESS ENTER- HOW DO I FIX THIS
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
Expand the column width...
T
tedmi
Set the number format to something other than scientific.
C
cb
whatever all have said nothing is working!!
Jim Thomlinson said:Expand the column width...
B
Bob I
Elect to format the Cell to display in the desired manner.
Right click on the cell, and pick Format cell
Right click on the cell, and pick Format cell
G
Gord Dibben
Have you tried formatting to Special>Zip Code?
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP