| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "cannot Empty the Clipboard" strange message | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Strange "FormatCells" behaviour | Excel Worksheet Functions | |||
Threaded Mode
