Pop-Up Thingie

>>> Magnum BBS <<<
  • Home
  • Forum
  • Files
  • Log in

  1. Forum
  2. Usenet
  3. COMP.APPS.SPREADSHEETS
  • Google Sheets: Date Format

    From Andreas Borutta@21:1/5 to All on Thu Aug 2 08:34:20 2018
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Andreas Borutta@21:1/5 to Luuk on Sat Aug 4 11:05:03 2018
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luuk@21:1/5 to Andreas Borutta on Sat Aug 4 10:51:08 2018
    On 2-8-2018 08:34, Andreas Borutta wrote:
    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


    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 )

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luuk@21:1/5 to Eike Rathke on Sat Aug 4 13:42:32 2018
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Eike Rathke@21:1/5 to All on Sat Aug 4 11:28:44 2018
    * 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/

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • Who's Online

  • Recent Visitors

    • Scanline
      Sun May 15 23:35:34 2022
      from Dublin via Telnet
    • Keyop
      Sun May 15 22:47:22 2022
      from Huddersfield, West Yorkshire via Telnet
    • Guest
      Sun May 15 20:37:02 2022
      from 11 via Telnet
    • Guest
      Tue May 17 00:32:25 2022
      from 11 via Telnet
  • System Info

    Sysop: Keyop
    Location: Huddersfield, West Yorkshire, UK
    Users: 112
    Nodes: 8 (1 / 7)
    Uptime: 223:21:30
    Calls: 2,466
    Calls today: 1
    Files: 8,610
    Messages: 1,881,816

© >>> Magnum BBS <<<, 2022