Date auto-formatting
Date auto-formatting
Tried adding a value in a cell as 9 - 10 to track the time 9 to 10, the value changed as 09/10/09 . Works the same as in Excel.
So, tried adding 9 - 9.30, the value changed as 09/09/30. Excel maintains it as 9 - 9.30 only.
Finally, I added it as 9 - 9:30 and it worked.