How do I customize the cells so that if a person puts the mm/dd/yy hh into an
inputbox within my vba code it shows up in the cell as mm/dd/yy hh:00?

The people using this code are lazy and don't want to type :00 after each
hour.

Everytime I try to use the custom feature it tells me it won't work and to
use one of the built in formats. hmmm.

Anyone know of a way to do this??? Thanks :)