View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ahdoj ahdoj is offline
external usenet poster
 
Posts: 1
Default Number to time conversion

I'm sure the answers here, but I can't sort it out.

I have data entered as general number with no punctuation that needs to be
converted to military time. How do I convert it without losing the time
entered?