Thread: Entering Seconds but displaying minutes & seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveWHAC DaveWHAC is offline
external usenet poster
  
Posts: 4
Default Entering Seconds but displaying minutes & seconds
I'm trying to set up a spreadsheet so that I can enter seconds into a variety
of cells e.g. 85 but I want it to be displayed as 1:25 when looking at the
spreadsheet.

Can anyone help ?
Reply With QuoteReply With Quote