Then go format as date on the cell
- 1 Post
- 135 Comments
Do =1/2 see what it gives
1/2 = 0.5 Excel counts dates 1 from 01/01/1900. Entering 0.5 and formatting as date and time gives: 00/01/1900 12:00:00 because of course it does.
then_three_more@lemmy.worldtoMicroblog Memes@lemmy.world•Wearing socks *is* a social constructEnglish25·2 days ago"Yes, but that doesn’t automatically mean it’s wrong or a bad thing.
then_three_more@lemmy.worldto Unpopular Opinion@lemmy.world•Languages with upper and lower case letters should just pick oneEnglish1·5 days agoNo, one will be seen as aggressive and or uneducated the other as lazy and or uneducated.
then_three_more@lemmy.worldto No Stupid Questions@lemmy.world•What is this clock icon in my phone status bar? [solved]2·5 days agoAny reminders set in any reminders/task type apps? My phone sometimes picks up those as alarms.
then_three_more@lemmy.worldto Fuck AI@lemmy.world•Facebook is starting to feed its Meta AI with private, unpublished photos36·5 days agohttps://web.archive.org/web/20250628010642/https://www.theverge.com/meta/694685/meta-ai-camera-roll
So you don’t need to sign up to the verge to read
then_three_more@lemmy.worldto UK Nature and Environment@feddit.uk•Met Office should name storms after fossil fuel companies, say campaignersEnglish6·5 days agoI think the point is to try to get people talking about it in the way people did about the Boaty McBoatface thing.
then_three_more@lemmy.worldto You Should Know@lemmy.world•YSK - Prune juice helps with constipation, but don't drink too much of it31·5 days agoA warriors drink
Serious money bags. Not only have they bought somewhere, they’re redecorating it and getting rid of the carpet the old owner left!
Exactly. Buying a carpet implies they’ve already bought somewhere to fit the carpet
Somewhere at Microsoft there is, presumably a Teams Team team.
then_three_more@lemmy.worldto A Comm for Historymemes@lemmy.world•It's honest work!English15·8 days agoAlso, I got a manor house and 30 acres of land for farting.
then_three_more@lemmy.worldto World News@lemmy.world•Jacky Jhaj: British man charged over mock Disneyland wedding to child had been investigated by BBCEnglish10·8 days agoFtfy
You haven’t seen Britain since 1490?
then_three_more@lemmy.worldto Buy European@feddit.uk•Tesla's European sales slump for fifth month11·8 days agoOp even put it as a quote so you didn’t even need go to the article. Its compared to sales last year (last may against this may)
People would buy more than just bare essentials because people want things
People would buy less and ecconomies (rightly or wrongly) rely quite a lot on people buying more than they need. There’s a reason economics are scared of deflation. The fear of deflation was why interest rates where so low after the 08 crash and even lower during the pandemic.
Also, other appreciating assets have some use within the wider economy. Shares you’re ingesting in a company that produces goods or services so they can spend that money on growing their business, bonds/guilts you’re enabling the issuer to borrow more to do whatever they need to do with that money (in the case of government bonds think roads, hospitals and bombs).
There’s no intrinsic value to fiat currency.
True. There isn’t to bitcoin either. What fiat has is stability and public confidence. When it looses stability that’s when things are bad. Bitcoin has proved itself extremely volatile, its about 16 years to become stable and it never has. Because bitcoin coin is so dominant in the crypto market I can’t see any crypo becoming stable while it exists.
I see what you’re saying now. You’re basically describing deflation. Yeah people would buy bread (and other essentials to live) but as their currency would be more valuable tomorrow they’d put off buying non essentials. In fiat currency this is seen as prices dropping in bitcoin is seen as the value of the bitcoin going up.
Why would I buy a non essential today when I know it’ll be 10% cheaper tomorrow?
Why would I use my bitcoin to buy anything non essential when if I wait until the next spike it’ll be 30% more valuable than today?
The answer of course is I wouldn’t. I’ll buy it later when it’s 10% cheaper for my fiat currency or 30% cheaper if I’m using bitcoin. It’s not an essential so why spend more to get he same thing.
Currency needs stability in fiat currency to much instability is described in terms of inflation and deflation. Because bitcoin is more of an investment than a currency it’s described as it going up and down.
As there’s no intrinsic value to bitcoin and because there’s no central backing working to maintain the stability it’ll never be anything other than a speculative investment for people who’re already rich or the few who get lucky to make some actual useable money off.
Dementia must be really bad if he thinks he can
Weird. When I entered 0.5 as a raw figure it gave me Jan 0, 1900 at 12 pm.