View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ViestaWu ViestaWu is offline
external usenet poster
 
Posts: 48
Default strange about ":"

Dear all,

just now I input 1:198 in one cell of my worksheet, it shows me 0.17916(6 is
cycling). I feel strange, cause I havn't input "=" befor it. and I don't know
what kind of operation Excel does to me. try with 1:60, result is 0.833333333.

and I found when the number in position of 198 is large than 59(from 60), it
will does this strange thing. if the number is smaller than and equal to 59,
the data will be the time.

could anyone give me an explanation that what excel does to me?

thank you