VBA Help

[nrfems83]

At one time I was able to obtain a VBA code that allowed me to enter military times into a cell without having to use a semicolon.

Does anyone have any ideas or a code that can assist me?

Thanks in advance!!!

[raypayette]

Click Format, Cells, Number, Custom and specify hmm or whatever you wish!

[Sun Li]

In VBA you can also use Format function at run-time.

eg: Format(Value, "dd-mmm-yy") will convert a date value 01/01/2007 to 01 -Jan-07

Hope this helps

cheers