LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Trouble keeping the time format

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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HAVING TROUBLE KEEPING MY SPREADSHEET FORMULAS PERMANENT Todd Excel Discussion (Misc queries) 1 March 1st 08 02:45 PM
Time format to number while keeping value Jim Excel Worksheet Functions 2 January 12th 06 05:45 PM
Time Keeping Timeless Excel New Users to Excel 3 December 4th 05 01:43 AM
I am having trouble keeping numbers formatted in a Pivot Table Liana H Excel Discussion (Misc queries) 1 April 22nd 05 07:43 PM
time keeping Jim[_22_] Excel Programming 2 February 4th 04 04:03 AM


All times are GMT +1. The time now is 10:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"