LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
EJC EJC is offline
external usenet poster
 
Posts: 1
Default Time in combo boxes change to decimals when printing

I have a work hours spread sheet that has combo boxes for
start and end times within certain days. I have the combo
boxes linked to the cell behind it and populated with
hours of the day. The times show up fine when selected,
such as 6:00; when I print the sheet or use print preview,
the value in the combo box then displays 0.25 (like a
quarter of a day). I reselect the box and can repopulate
6:00. It does the same thing for dates too.

Is there code in VB that I can write that will allow these
values to be printed as times, and not as decimals?
 
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
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
Macro Printing One Sheet with one change at a time JohnHB Excel Discussion (Misc queries) 0 February 6th 07 04:57 PM
Selecting subsets using combo boxes or list boxes CLamar Excel Discussion (Misc queries) 0 June 1st 06 07:43 PM
Questions on combo boxes and list boxes. Marc New Users to Excel 1 March 14th 06 09:40 AM
List boxes/combo boxes Tibow Excel Programming 3 February 17th 04 12:35 PM


All times are GMT +1. The time now is 02:18 PM.

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

About Us

"It's about Microsoft Excel"