View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BigBuck98
 
Posts: n/a
Default Format cell to show colon

Is there any way that I can format a cell to insert a colon three spaces to
the left from the end of any group of numbers that I type in the a cell?
Examples 9:15 10:15

Thanks in advance,
Gordon