Thread: Converting decimal number to hh:mm format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Lowenstein Jeff Lowenstein is offline
external usenet poster
  
Posts: 14
Default Converting decimal number to hh:mm format
I have a large amount of data that I want to enter. I would like to enter it
in the format of #### ( i.e. 1234) and have it automatically converted to
12:34 PM. Is there a way to do this? If so, How?
Reply With QuoteReply With Quote