View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
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