Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |