View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
yimkhoc yimkhoc is offline
external usenet poster
 
Posts: 7
Default Formatting cells with Time data

I'm trying to set up my spreadsheet to format my cells to hhmm, but every
time I try to enter data into the cells, the system automatically converts
the hours I've entered into a date and leaves the time value at 0

any suggestions as to what I'm doing wrong?