|
|
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
 |
|
|
Thread Tools | Display Modes |
Apr 29th, 2002, 01:03 PM
|
#1 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
Hi.
I want to format a date as d/m. I can only find the american m/d which just won't makes sense here! This is not on the date or custom menu. And yes, my settings are set to English UK on the control panel. I have no idea how to create custom formats which I suspect might be required. Thanks, RET79 |
|
|
|
Apr 29th, 2002, 01:12 PM
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Southfield,MI USA
Posts: 1,030
|
Hiya,
What happens if you go to Format-Cells-Custom and set the custom format as "d/m" (w/o the quotes) If I understand you correctly your trying to get a date like 4/16/02 to show as 16/4. I could get excel to do this on my machine - does excel spit that out on yours? Adam |
|
|
|
|
Apr 29th, 2002, 01:15 PM
|
#3 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
It does work, thanks !
Silly me, I didn't realise you could just type in what you wanted in the custom bit, I need to get some glasses - DOH! RET79 |
|
|
|
|
Apr 29th, 2002, 01:32 PM
|
#4 | |
|
MrExcel MVP
Join Date: Feb 2002
Location: The Hague
Posts: 50,319
|
Quote:
Regional Settings (Control Panel) on the General tab, choose English [United Kingdom] Excel will adapt accordingly. |
|
|
|
|
|
Apr 29th, 2002, 01:37 PM
|
#5 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
Aladin,
Sadly, I have done that this afternoon, and it came up English UK so yes I was disappointed that even with this setting correct that I was still getting american formats. The same thingis true for my laptop  I will check again tomorrow to be absolutely sure. RET79 |
|
|
|
|
May 2nd, 2002, 03:46 PM
|
#6 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
Hi RET70 it Jack, Uk dates are backwards alwyas rem this to Excel, sadley us UK guys never made Excel
 the yanks did.custom as explained to day month year D DDD mmmm yyy for long in custom might only see dd mm yy select this as format to a cell reading -NOW() this should give as you want if not i have a extreamly long formula that will force excel to go Thursday 5th April 2002 no matter what. As always Brits bing British and different, we like our dates this way.. days before months as they sould be...
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
May 2nd, 2002, 03:58 PM
|
#7 |
|
MrExcel MVP
Join Date: Feb 2002
Location: Christchurch New Zealand
Posts: 1,030
|
only problem is if you have 4/5 11/3 3/11 what date are you actually getting there should be a world standard not back to front examples...
|
|
|
|
|
May 2nd, 2002, 04:01 PM
|
#8 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
OK so I am biased saying this but
22/4/2002 is the logical way for dates. You are starting with the days, then month, then years. Who on earth thought up m.d.y I have no idea. Oh, and we drive on the correct side of the road too  RET79 |
|
|
|
|
May 2nd, 2002, 04:04 PM
|
#9 |
|
Board Regular
Join Date: Feb 2002
Posts: 3,065
|
RET70 easy felloor im with you the yanks are our buddies... remember.. they hook right and month before date
so what... just make life hard thats all... have you solved this by custom or need my wicked formula....
__________________
Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you" |
|
|
|
|
May 2nd, 2002, 04:06 PM
|
#10 |
|
Board Regular
Join Date: Mar 2002
Location: England, UK.
Posts: 526
|
I solved it with custom, but by all means submit your wicked formula..
RET79 |
|
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
