#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 137
Default Calendar date format

Hi,

Is it possible to change the pop up calender to UK date format within excel?
You can temporarily chage it within the format cells section, however it
reverts back to US format for each date selected.

Thanks,
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 459
Default Calendar date format

Darren wrote:
Hi,

Is it possible to change the pop up calender to UK date format within
excel? You can temporarily chage it within the format cells section,
however it reverts back to US format for each date selected.

Thanks,



Hi Darren,

maybe you can change your date settings from Control Panel, Regional
Settings, but this will influence all your PC...

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 137
Default Calendar date format

Hi Franz,

Thanks for your reply - I've tried this - unfortunately this doesn't affect
the outcome.

I'm not sure whether there is a way of customising the pop-up calendar..??

Any help would be appreciated...

cheers
Darren


"Franz Verga" wrote:

Darren wrote:
Hi,

Is it possible to change the pop up calender to UK date format within
excel? You can temporarily chage it within the format cells section,
however it reverts back to US format for each date selected.

Thanks,



Hi Darren,

maybe you can change your date settings from Control Panel, Regional
Settings, but this will influence all your PC...

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy



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
How do I create a schedule from a list of dates ? Gavin Morris Charts and Charting in Excel 2 October 28th 10 04:08 PM
Cell date format doesnt change Jon Excel Worksheet Functions 5 March 7th 06 04:52 PM
Enforcing a date format on a cell/column ProdigalShawne Excel Discussion (Misc queries) 1 February 22nd 06 07:13 PM
format date in excel Nigel Excel Discussion (Misc queries) 2 September 15th 05 09:52 PM
Compare dates (one cell not in date format) craigcsb Excel Discussion (Misc queries) 5 June 28th 05 05:07 PM


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