Google Sheets: Date Format

[Andreas Borutta]

Hi.

In Google Sheets the format code "ddd" for e.g. 2018/08/01 results in
"Mi." (German interface)

I need it without the dot. Just "Mi".

Is that possible?

The page
https://developers.google.com/sheets/api/guides/formats
doesn't give a hint how to solve the problem.

Thanks for your help.

Andreas
--
http://fahrradzukunft.de

[Luuk]

there was a discussion about this on the internet in 2003:
https://www.typografie.info/3/topic/28675-abk%C3%BCrzungspunkt-nach-wochentag/

The writers there where not clear about the right way to go ... ;)

But, praise yourself lucky you do not live in Catalonia
(
https://www.quora.com/How-are-days-of-the-week-abbreviated-in-various-languages
)


The real solution would be to find out how the days of the week are
shortened officially, and than (if this calls for a change) file a bug
report with Google )

[Andreas Borutta]

Luuk schrieb:

> On 2-8-2018 08:34, Andreas Borutta wrote:

>> In Google Sheets the format code "ddd" for e.g. 2018/08/01 results in
>> "Mi." (German interface)
>>
>> I need it without the dot. Just "Mi".

> there was a discussion about this on the internet in 2003:
> https://www.typografie.info/3/topic/28675-abk%C3%BCrzungspunkt-nach-wochentag/
>
> The writers there where not clear about the right way to go ... ;)
>
> But, praise yourself lucky you do not live in Catalonia
> (
> https://www.quora.com/How-are-days-of-the-week-abbreviated-in-various-languages
> )
>
>
> The real solution would be to find out how the days of the week are
> shortened officially, and than (if this calls for a change) file a bug
> report with Google )

Thanks for your hints.



Andreas
--
http://fahrradzukunft.de

[Eike Rathke]

* Luuk, 2018-08-04 08:51 UTC:

> file a bug report with Google

How does one file a bug against Google Sheets btw?

Eike

--
OpenPGP/GnuPG encrypted mail preferred in all private communication.
GPG key 0x6A6CD5B765632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A
Use LibreOffice! https://www.libreoffice.org/

[Luuk]

On 4-8-2018 13:28, Eike Rathke wrote:
> * Luuk, 2018-08-04 08:51 UTC:
>> file a bug report with Google
>
> How does one file a bug against Google Sheets btw?
>
> Eike
>

Start Googling for: report bug google sheets

First Link (for /me):
https://stackoverflow.com/questions/12106497/how-to-report-a-bug-for-google-drive-google-docs

The page contains a link to the 'Google Help forum':
https://productforums.google.com/forum/?visit_id=1-636689793037879714-2750156247&hl=en&rd=1#!forum/docs

But, indeed, there is mentioned that this might be a 'problem':
<quoot>Reporting issues to Google has always been a nightmare. –
Sébastien Jan 2 '14 at 10:18</quoot>

Also:
https://productforums.google.com/forum/#!topicsearchin/docs/category$3Areport-an-issue%7Csort:relevance%7Cspell:false

https://cloud.google.com/support/docs/issue-trackers

[Eike Rathke]

* Luuk, 2018-08-04 11:42 UTC:

> On 4-8-2018 13:28, Eike Rathke wrote:
>> * Luuk, 2018-08-04 08:51 UTC:
>>> file a bug report with Google
>> How does one file a bug against Google Sheets btw?

> Start Googling for: report bug google sheets

> [... some links ...]

Of which none leads to a bug tracker of any sort but all some "help" and
"support" forum / google group where maybe some Google staff will
extract information at good will or won't.

> But, indeed, there is mentioned that this might be a 'problem':
> <quoot>Reporting issues to Google has always been a nightmare. –
> Sébastien Jan 2 '14 at 10:18</quoot>

So nothing changed. It's a PITA and effectively one can't report a bug
and track if and when it's fixed.