View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dylan
 
Posts: n/a
Default why does dividing numbers give me dates and not numbers?

Hello,
I am making a frequency table that includes frequency, frequency %, and cum
frequency, but I cannot accuarately input the data in the frequency % column.
The total frequency I have is 65, and for the first bin, there is a
frequency of 4. So when I either input =4/65, 4/65, or E3=E9 (the boxes the
bin frequency is in, and the total number) it does not give me a number, but
instead gives me the date, April 1, 1965, or january 00 if i use the = key.
And even if i do the division on a calculator, and then input 0.06 it will
give me Jan - 00 as an answer. whats up?