LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"