+ Reply to Thread
Results 1 to 3 of 3

What's that?

  1. #1
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    What's that?

    Add this custom format to any cell
    [$-F4028C1]\:mm:ss
    The type any Date or Time(time is prefered)
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: What's that?

    http://stackoverflow.com/questions/8...at-what-is-409

    That seems to describe a similar problem, your number looks like hex so maybe this is the answer?
    To clarify what others have said:

    The [$-409] is a locale code, given in hexadecimal. Prefixing a date with a certain locale code determines what is shown when you use the various date time format codes. For example using the date

    November 28, 1973 11:28:13 AM

    as an example for the following table:

    Format Code 409 (English United States) 804 (Chinese PRC)
    =========== =========================== =================
    m 11 11
    mm 11 11
    mmm Nov 十一月
    mmmm November 十一月
    d 27 27
    dd 27 27
    ddd Mon 二
    dddd Monday 星期二
    y 73 73
    yy 73 73
    yyy 1973 1973
    yyyy 1973 1973
    AM/PM AM 上午
    So in the end the same format code with two different locale identifiers, gives different results:

    [$-409]mmmm dd yyyy h:mm AM/PM
    November 27 1973 11:28 AM


    [$-804]mmmm dd yyyy h:mm AM/PM
    十一月 27 1973 11:28 上午
    Since finding a list of locale codes is like pulling teeth, here are some references:

    Language Identifier Constants and Strings (Primary source)

    Windows Locale Codes Sorted by Locale

    Windows Locale Codes Sorted by Locale

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: What's that?

    Thank yudlugar for sharing this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1