View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default cannot enter correct numbers in cells

jb

A samll example of the type of numbers you are entering would be handy.

And a small example of what they turn into when you hit enter.


Gord Dibben MS Excel MVP

On Sat, 7 Oct 2006 14:12:01 -0700, jb wrote:

Every time I enter a number in a cell and click enter I get a date format or
a string of numbers. I format the cell and the same thing happens. What is
causing this?