Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 172
Default Combobox Date format change

Thank you Greg.
Perfectly done.

"Greg Wilson" wrote in message
...
You could just specify this format: "dddd MMMM dd yyyy"

To answer your question, the "Short Date" and "Long Date" formats are set
through the Control Panel. FWIW, my take on these formats is that they
allow
developers to specify one or the other format types (Long or Short) in
their
programs as opposed to a specific format. This enables the computer owner
to
control the format and maintain consistency while running multiple
programs
(particularly important for a business).

For Windows 2000 Profressional:
Control Panel Regional Options Date tab
In the Long Date window specify: dddd MMMM dd yyyy

For Windows XP Professional:
Control Panel Regional and Language Options Regional Options tab
Click the Customize button Date tab...

Regards,
Greg



Reply
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
Format Date ComboBox Blobbies Excel Discussion (Misc queries) 4 January 10th 08 08:40 AM
Format date in combobox susan Excel Programming 1 September 6th 06 09:56 PM
Combobox/Rowsource - loses date/time format systemx[_14_] Excel Programming 2 July 31st 06 10:24 AM
ComboBox Date Format Problem CiaraG[_5_] Excel Programming 2 February 15th 06 02:17 PM
Change a date in text format xx.xx.20xx to a recognised date format concatenator Excel Programming 1 November 24th 03 11:33 PM


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