NUMBERS NOT TYPING CORRECTLY
 

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS

NUMBERS NOT TYPING CORRECTLY
 

Expand the column width...
--
HTH...

Jim Thomlinson


"cb" wrote:

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS

NUMBERS NOT TYPING CORRECTLY
 

Set the number format to something other than scientific.
--
TedMi

NUMBERS NOT TYPING CORRECTLY
 

whatever all have said nothing is working!!

"Jim Thomlinson" wrote:

Expand the column width...
--
HTH...

Jim Thomlinson


"cb" wrote:

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS

NUMBERS NOT TYPING CORRECTLY
 

Elect to format the Cell to display in the desired manner.

Right click on the cell, and pick Format cell

cb wrote:
whatever all have said nothing is working!!

"Jim Thomlinson" wrote:


Expand the column width...
--
HTH...

Jim Thomlinson


"cb" wrote:


WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS

NUMBERS NOT TYPING CORRECTLY
 

Have you tried formatting to SpecialZip Code?


Gord Dibben MS Excel MVP

On Thu, 27 Mar 2008 14:44:00 -0700, cb wrote:

whatever all have said nothing is working!!

"Jim Thomlinson" wrote:

Expand the column width...
--
HTH...

Jim Thomlinson


"cb" wrote:

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS