I have a cell with time formatting in it. The cell displays as "8:00" due to time formatting. but if I copy>paste value it's .0498567434. Anyone know how I can the cell to actually contain 8:00? This is really frustrating. A lot of people seem to have issues with time formatting in excel but I can't find the right answer.
7/8/15 at 6:47pm