View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sako 338 sako 338 is offline
external usenet poster
 
Posts: 15
Default number/time format

can i format a cell so a user enters say 930 and on exit from the cell it
automattically formats to 9:30 (h:mm format)

thanks

sako 338