View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Numbers changing

Try giving those cells a different number format.
Select the cells
Format|cells|Number tab|Number
(with 0 decimal places???)

You may have to widen the column to see the value.


Justme-in-Az wrote:

I'm having a problem with typeing number into a cell. I'm trying to put the
number 270073037038 and it is putting 2.70073E+11, infact every number I'm
putting in is showing that same number. The weird thing is, they all will go
to the correct hyperlink, or if you click on it the correct number shows.
What can I do to correct it? I'm using Excel 2007.

Thanks,
Heidi


--

Dave Peterson