Thread: Reformat existing 4 digit number as hh:mm?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carol Wolfe Carol Wolfe is offline
external usenet poster
  
Posts: 1
Default Reformat existing 4 digit number as hh:mm?
I have a column of 3 and 4 digit numbers. I would like to insert a colon :
to the immediate left of the 2 numbers on the far right of the cell. Is
there a way to do this easily?
Reply With QuoteReply With Quote