A date should NEVER be like this

[DAEMANO]

Originally Posted by sdemo

^ I hear you, but maybe Excel should treat leading zeroes as significant digits without me having to add a god damn apostrophe

Haha I hear ya!

Select Column > Format Cells > Custom > In the type box Overwrite "General" with zeros for the number of zeros your number sequence should contain (eg. if your number sequence should be 0123456, then type in 0000000)

OR

Select Column > Data Tab click "Text to Columns" > Delimted (click "Next") > (click "Next" again) > Column data format (click "Text") > (click "Finish").

Either way should do the trick. If not, you're boned

[bcj]

YYYY/MM/DD
Sorting.
So much easier this way to figure out where the script borked.
Or where that picture was filed.
Most significant to least significant.
Not going to change to make your feelers unsigned.

[mdm]

Originally Posted by themadscientist

Actually, the first country that landed a spacecraft on the moon was Soviet Union.

[mdm]

YYYY/MM/DD - makes sense, sorts correctly
DD/MM/YYYY - makes sense, does not sort correctly
MM/DD/YYYY - WTF?

[mdm]

Originally Posted by Atticus808

Americans gonna American

miles?


MILES?

1 mile = 1609 metres

1 kilometre = 1000 metres


if someone wants to know how many metres are in 3km. 3x1000 = 3000
in miles..... 3 x 1609 metres = what?

It gets worse if you stick to US system.


1 km = 1000 m
1 m = 100 cm
1 cm = 10 mm

1 L = 1000 mL


1 kg = 1000 g

by the way, 1 litre of water weighs exactly 1 kg

Now

1 mile = 1760 yd
1 yd = 3 ft
1 mile = 5280 ft
1 ft = 12 in
and then you get into 8ths, 16ths, 32nds... WTF?

Also 1 US gallon = 8 pints
1 pint = 16 fl oz

And 1 pint of water weighs 1.042 pounds.... WTF?
1 pound = 16 oz

[Tcoat]

Well for a change the Americans are not the odd man out since apparently anything goes for Canada .
And apparently much Africa don't have dates at all!


Cyan
DMYAsia (Central, SE, West), Australia (24), New Zealand (5), parts of Europe (ca. 675), most of Latin America (570), North Africa; India (1240), Indonesia (250), Nigeria (170), Bangladesh (150), Russia (140)


Yellow
YMDChina (1360), Koreas (75), Taiwan (23), Hungary (10), Iran (80), Japan (130), Lithuania. Known in other countries due to ISO 8601.1660


Magenta
MDYBelize, Federated States of Micronesia, United States (320)320


Red
DMY, MDY Philippines (100), Saudi Arabia (30)130


Green
DMY, YMD Albania (3), Austria (9), Croatia (4), Czech Republic (11), Denmark (6),[1] Germany (81),[2][not in citation given] Hong Kong (9), Kenya (905), Latvia (2), Macau (1), Nepal (50), South Africa (54), Slovenia (2), Sweden (10)[3]287


Grey
DMY, MDY, YMD Canada (40)

[Ultramaroon]

Hungary gets it.

[Captain Snooze]

.

[Tcoat]

[sdemo]

Originally Posted by DAEMANO

Haha I hear ya!

Select Column > Format Cells > Custom > In the type box Overwrite "General" with zeros for the number of zeros your number sequence should contain (eg. if your number sequence should be 0123456, then type in 0000000)

OR

Select Column > Data Tab click "Text to Columns" > Delimted (click "Next") > (click "Next" again) > Column data format (click "Text") > (click "Finish").

Either way should do the trick. If not, you're boned

Method 1 displays the zeroes but they're not actually values in the cell; Method 2 is where it's at. I call shenanigans regardless :p

[cdrazic93]

everyone talking about our fuckin weird system, dont get me started on inches. Why the hell does someone think that the system of 10s isnt good? really?

At the same time, who thought time should be measured in 60' seconds...

[themadscientist]

I actually love the metric system. Base 10? Why the hell wouldn't you use that. I hate laying under a car doing fractions in my head.

[Packofcrows]

I say Year Month and day.


In Mexico it's day, month and year iirc

[Ashikabi]

This thread was not what I expected...