Trouble keeping the time format

T

TomP

I'm using a data validation tool to select a group of times available to
choose from. It is formatted in "1:30 AM" ... etc. The source is
formatted that I like it and even the drop down works as I like it.

The problem is, someone wrote a macro that causes my time formats to appear
in decimal notation.

Does anyone know what to look for to see where in the macro that causes this?

Thank you,
 
M

Michael

Should look for an instruction that reads:
.NumberFormat="General" 'Maybe other format, then change the General to
"[$-409]h:mm AM/PM;@"
 
Top