Convert Number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Qui-Gon.Jinn - 04 Feb 2007 23:23 GMT

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

Reply to this Message

T. Valko - 05 Feb 2007 03:02 GMT

See this:

http://cpearson.com/excel/DateTimeEntry.htm

Biff

> 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

Reply to this Message