Convert Number

Q

Qui-Gon.Jinn

Please can you help i want to type in say 9 into a cell but it will change
automatically to 09:00 and the same for 1130 to 11:30 and 12 to 12:00 i
have looked at formulas but cant work this out i can get 9 to 09.00 but not
what i want

Any help appreciated and Thnk you in advance
 
Top