View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Demosthenes Demosthenes is offline
external usenet poster
 
Posts: 36
Default Time input simplification

Hi,

I want to set up a worksheet so that an input of "9a" or "1p" will
autocorrect to "9:00 AM" and "1:00 PM." What's the best way to do that?

Thanks,