Thread: Time formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mick Southam Mick Southam is offline
external usenet poster
 
Posts: 17
Default Time formatting

Hi

Does anyone have a method for entering any number, say, 0800 and it will
automatically insert a colon in between the 08 and 00. I have a method of
automatically changing data entered in lower case to upper case, but cannot
work this one out - Can you?

--
Kind Regards

Mick