Open Menu
AllLocalCommunitiesAbout
lotide
AllLocalCommunitiesAbout
Login

Perspective

⁨1158⁩ ⁨likes⁩

Submitted ⁨⁨8⁩ ⁨months⁩ ago⁩ by ⁨Track_Shovel@slrpnk.net⁩ to ⁨[deleted]⁩

https://slrpnk.net/pictrs/image/4a91e231-70cf-4068-813b-1ac74a705f64.png

source

Comments

Sort:hotnewtop
  • Mammothmothman@lemmy.ca ⁨8⁩ ⁨months⁩ ago

    Libre Office: the glass is Feb 1st

    source
    • Rolive@discuss.tchncs.de ⁨8⁩ ⁨months⁩ ago

      Also the civilized world.

      source
      • HK65@sopuli.xyz ⁨8⁩ ⁨months⁩ ago

        Some countries use YYYY MM DD which is also sane.

        source
        • -> View More Comments
    • IvanOverdrive@lemm.ee ⁨8⁩ ⁨months⁩ ago

      In JavaScript it would be February 2.

      source
      • wander1236@sh.itjust.works ⁨8⁩ ⁨months⁩ ago

        In JavaScript it would be “true” for some reason

        source
        • -> View More Comments
  • FelixCress@lemmy.world ⁨8⁩ ⁨months⁩ ago

    1st of February.

    source
  • hOrni@lemmy.world ⁨8⁩ ⁨months⁩ ago

    The realist: This is piss.

    source
    • RestrictedAccount@lemmy.world ⁨8⁩ ⁨months⁩ ago

      It was once

      source
    • zedgeist@lemm.ee ⁨8⁩ ⁨months⁩ ago

      Or would that just be pissimistic?

      source
  • quink@lemmy.world ⁨8⁩ ⁨months⁩ ago

    That’s 0.5 more than January 0th, 1900.

    source
  • chiliedogg@lemmy.world ⁨8⁩ ⁨months⁩ ago

    I have the opposite problem. Half the time no matter how much I change the formatting on the cells I can’t get a table to sort by date. It insists on alphabetical instead, so you’ve got 1/12/2024 ahead of 1/13/2023.

    source
    • ryo@lemmy.eco.br ⁨8⁩ ⁨months⁩ ago

      The solution for that is using a sane format for dates.

      source
      • FinishingDutch@lemmy.world ⁨8⁩ ⁨months⁩ ago

        When I worked in radio production, basically everything was formatted like YYYY-MM-DD. Which means stuff is really to find and properly in chronological order.

        I still usw the MM-DD format for my own file formatting, even though DD-MM is the Dutch standard.

        YYYY-MM-DD is god’s perfect date notation as far as I’m concerned.

        source
      • chiliedogg@lemmy.world ⁨8⁩ ⁨months⁩ ago

        Yeah - I don’t get to determine what date format 3rd party reports are generated in before I import into excel.

        But excel has formatting options specifically designed to address this that it just ignores half the time.

        source
    • MisterFrog@lemmy.world ⁨8⁩ ⁨months⁩ ago

      This is because you’ve accidentally input the values as text somewhere along the line. First make sure your format is set to date in the range in question.

      Make use of the DATEVALUE formula in blank column =DATEVALUE(your_range). This will output your range as a number. Note that your_range needs to be in your computers date format (I have mine set to YYYY.MM.DD, so that what I have to use, else it won’t work. You might be American, so your dates would need to be MM/DD/YYYY) for DATEVALUE to recognise the text as a date string.

      Then copy the output, paste as values only (alt, h, v, v), then copy that and paste it back into you range.

      Make sure the format is set to date and you’re laughing.

      source
  • MisterFrog@lemmy.world ⁨8⁩ ⁨months⁩ ago

    I have never run into this problem and wondered why. I realised it’s because I instinctively put an equal sign whenever doing a fraction.

    source
  • skvlp@lemm.ee ⁨8⁩ ⁨months⁩ ago

    This is not a glass.

    source
    • Track_Shovel@slrpnk.net ⁨8⁩ ⁨months⁩ ago

      Parrot says otherwise

      youtu.be/iKva06hj270

      source
  • Capricorn_Geriatric@lemmy.world ⁨8⁩ ⁨months⁩ ago

    Realist: the glass is plastic

    source
  • MonkderVierte@lemmy.ml ⁨8⁩ ⁨months⁩ ago

    Physicist: state is undecided

    source
  • Sparky@lemmy.blahaj.zone ⁨8⁩ ⁨months⁩ ago

    The more lines you add in a program, the more stuff can break which is what I assume happens with excel when it thinks something is a date.

    Spreaking from experience, my code is in a metaphorical sense a building that is built to lean towards the wind, but when the wind stops, the entire thing collapses. I assume that’s how excel’s code base works too.

    source
  • WalrusDragonOnABike@lemmy.today ⁨8⁩ ⁨months⁩ ago

    Pretty sure I’ve had excel do something like change 1/2 into March 6th…

    source
    • xpinchx@lemmy.world ⁨8⁩ ⁨months⁩ ago

      Or a UPC into scientific notation…

      I’ve been doing heavy Excel/data work for years and never have I ever wanted or needed anything in scientific notation.

      source