Posted to microsoft.public.excel.programming
|
|
Time formatting
See
http://cpearson.com/excel/DateTimeEntry.htm
In article ,
"Mick Southam" wrote:
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?
|