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: 44
Default date reverts to serial number

I have a drop down box in a userform that allows the user to select
from the seven days of the week. These days are stored on a sheet in
this format: dddd - mm/dd/yyyy and appear as such when the user clicks
on the drop down arrow. However once the desired day is selected it
shows the serial version of the date. Any suggestions on a way to set
it show that after the user selects the date it still shows the date
and not the serial

 
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
how to return a serial number to a date Holly Excel Discussion (Misc queries) 7 March 11th 10 04:50 AM
how to now what date represent a serial number? cubanoluso Excel Worksheet Functions 4 April 25th 07 03:54 PM
convert serial number into date santhu Excel Discussion (Misc queries) 2 October 28th 06 10:27 AM
Serial number of Date Gazzr Excel Worksheet Functions 2 March 24th 06 08:59 AM
Formatting a date as a serial number David Excel Programming 4 October 28th 03 03:57 PM


All times are GMT +1. The time now is 12:37 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"