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,

Should look for an instruction that reads:
.NumberFormat="General" 'Maybe other format, then change the General to
"[$-409]h:mm AM/PM;@"
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"TomP" wrote:

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,

It worked like a charm! Thank you so much!

Merry Christmas & Happy New Year!

Tom

"TomP" wrote:

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,