Trouble keeping the time format

  • Thread starter Thread starter TomP
  • Start date Start date
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,
 
Should look for an instruction that reads:
.NumberFormat="General" 'Maybe other format, then change the General to
"[$-409]h:mm AM/PM;@"
 
It worked like a charm! Thank you so much!

Merry Christmas & Happy New Year!

Tom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
number format change 1
number format? 4
Formatting short times 2
Auto-formatting Time with a Query Table 4
International Date formatting 4
Time formatting issues 3
Time Calculations Help 4

Back
Top