Afternoon folks,

Could anyone help here? when i create a form that when you type in the time it sends that data to the controlsource cell - no probs there but the form changes to a decimal number eg 09:00 when typed changes to 0.375 on the form, i would like this to stay as 09:00 (or whatever the value is when typed in 24hr format.

oops - im using excel 2000 at my work to do this.

Any Ideas?