I'm using Excel 2003.

I added 4 hours to time which works perfectly. When I want to get rid of
the formula, I use Copy--Paste Special--Values. The time displays
correctly in the cell but in the formula bar it shows 01/01/1900 along with
the time. When I format the cell as again to time hh:mm:ss, nothing changes
as I still see the date in the formula bar.

How do I stop this without have to go into each cell individually and delete
the date out?

Too crazy for me, what gives?