In spreadsheets, number formats are incorrect for British English

[emes81]

British English does not (in fact, most varieties of English do not) use the same formats as American English. Use of the American formats in British English contexts is confusing or even misleading (2/8/24 is 2 August in the UK, but February 8 in the US).

As a result, most of the number formats in this screenshot are incorrect in British English. In the example in the screenshot, they should read:

Saturday 21 September 2024
21/09/24 10:32:22
1,234.56 £4,567.89

For more information, see:
https://en.wikipedia.org/wiki/Date_and_time_notation_in_the_United_Kingdom

The currency sign always goes before the number:
https://en.wikipedia.org/wiki/Pound_sterling

The 12-hour am/pm clock is widely used in spoken language and some other contexts, but the 24-hour clock is appropriate in most written contexts. See, for instance, this BBC TV schedule and these Premier League fixtures:
BBC TV: https://archive.is/YjnS4
PL: https://archive.is/sIOtU

[Andrew-Dudov]

Hello @emes81 Thank your for your request. I created ticket 71176 with your bug.