Hello from Steved

Yes I have it VBA

Here is my issue I have A Pocket Computer with excel, it does not support VBA

Ok in cell B6 I type in 1430 I hit the enter key I need it to change to
2:30pm

I am wondering if this can be done. ie is thier a formula that could be used.

Thankyou.