View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default numbers in a cell change

Make the cell wider and/or change the format from General to Number.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"GeorgeA" wrote in message
...
Example: 610300012569 changes to 6.103E+11
--
GeorgeA


"Gord Dibben" wrote:

George

Post an example of the numbers you type and the formula you see when you

exit
the cell.

Or maybe one of the psychics in here will not need that info<g


Gord Dibben MS Excel MVP


On Sat, 1 Jul 2006 14:00:02 -0700, GeorgeA


wrote:

When I type numeric numbers in a cell they change to a type of formula

when I
exit the cell. How do I get them to stay numeric only?