View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
patoda patoda is offline
external usenet poster
 
Posts: 2
Default Cell Format for Time

I have a simple worksheet for entering values on specific dates and plotting
them. I am trying to add a column to record the time that the values are
taking but when I format a cell for time, the cell displays 0:00 for all
times entered. The formula line reads 3/10/1902 12:00:00 AM. This occurs
for any number values entered either in a time format or otherwise.