Hanna
My feedback
25 results found
-
133 votes
-
309 votes
-
255 votes
-
20 votes
An error occurred while saving the comment -
395 votes
An error occurred while saving the comment I always use YYYY-MM-DD, it's the easiest way for me and easiest to sort. I have it in all my documents
I can't use sheets at the moment, without both European ISO standards, and without find and replace it is useless, and I really think it looks great so far
"ISO standards (like SI/ISO 31-0 and ISO 80000-1) officially recommend using a non-breaking space (thin space) as a thousands separator (e.g., 1 000 000) and either a comma (,) or a point (.) as the decimal marker, with the choice depending on local custom, but not mixing them or using dots/commas for thousands. So, the format 100 000,50 (space for thousands, comma for decimal) is consistent with ISO/European conventions, while 100,000.50 (comma for thousands, point for decimal) aligns with US/English conventions.
Key ISO/SI Recommendations
Thousands Separator: A non-breaking space (thin space), used in groups of three digits, e.g., 1 234 567.
Decimal Marker: Either a comma (,) or a point (.), depending on country/language.
Avoid Confusion: Do not use commas or periods as thousands separators (e.g., avoid 1,000,000 or 1.000.000).
Examples in Practice
European/ISO Style: 1 234 567,89 (space thousands, comma decimal).
US/English Style: 1,234,567.89 (comma thousands, point decimal).
In Computing
Many programming languages (Python, Java, etc.) use the underscore _ as a literal digit group separator for code readability (e.g., 700_000_000).
Operating systems and software (like Microsoft Excel) allow users to set their regional preferences for these separators. "