Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: UK date format

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,045
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-04-29 12:15, RET79 wrote:
    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
    The underlying format will still be American though. You should check out why Excel doesn't follow your settings.

    Regional Settings (Control Panel) on the General tab, choose

    English [United Kingdom]

    Excel will adapt accordingly.


  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Christchurch New Zealand
    Posts
    1,030
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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...

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  10. #10
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I solved it with custom, but by all means submit your wicked formula..

    RET79

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •