The glass is...
-
This post did not contain any content.
The glass is at 50% capacity.
-
Me: the glass is half empty and the other half sucks!
I'm "fun" at parties. lol
Pissimist: the glass is full... Of piss.
-
The glass is at 50% capacity.
-
I just tested, entering “1/2” into excel results in “02-Jan”
Truly cursed.
Do =1/2 see what it gives
-
Do =1/2 see what it gives
0.5 but keeps the fraction in the formula bar.
That one doesn’t surprise me at all.
-
0.5 but keeps the fraction in the formula bar.
That one doesn’t surprise me at all.
Then go format as date on the cell
-
This post did not contain any content.
This always assumes that whatever's in the glass is desirable. If it's partially filled with piss, the optimist and pessimist roles would be reversed. Although Excel would remain the game.
-
Then go format as date on the cell
Jan 1, 1900
And as a time it’s exactly 12 PM
-
Jan 1, 1900
And as a time it’s exactly 12 PM
Weird. When I entered 0.5 as a raw figure it gave me Jan 0, 1900 at 12 pm.
-
This post did not contain any content.
LibreOffice: Jan 1, one half, one third
