The Picard Maneuver@lemmy.world to Microblog Memes@lemmy.worldEnglish · 1 month agoThe glass is...lemmy.worldimagemessage-square20linkfedilinkarrow-up1525arrow-down118
arrow-up1507arrow-down1imageThe glass is...lemmy.worldThe Picard Maneuver@lemmy.world to Microblog Memes@lemmy.worldEnglish · 1 month agomessage-square20linkfedilink
minus-squarethen_three_more@lemmy.worldlinkfedilinkEnglisharrow-up2·1 month agoDo =1/2 see what it gives
minus-squarewise_pancake@lemmy.calinkfedilinkEnglisharrow-up2·1 month ago0.5 but keeps the fraction in the formula bar. That one doesn’t surprise me at all.
minus-squarethen_three_more@lemmy.worldlinkfedilinkEnglisharrow-up2·1 month agoThen go format as date on the cell
minus-squarewise_pancake@lemmy.calinkfedilinkEnglisharrow-up1·1 month agoJan 1, 1900 And as a time it’s exactly 12 PM
minus-squarethen_three_more@lemmy.worldlinkfedilinkEnglisharrow-up1·1 month agoWeird. When I entered 0.5 as a raw figure it gave me Jan 0, 1900 at 12 pm.
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.
Then go format as date on the cell
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.