Even “Number Format: General” still omits the starting 0. I can’t even get it to show up if I lead with a space or a “-.” What is the trick? This is super-annoying.

  • Dookieman12@piefed.socialBanned
    link
    fedilink
    English
    arrow-up
    1
    ·
    3 months ago

    Change the number format to ‘Text’.

    General will attempt to apply the correct format based on cell contents. The numbers are making it implicitly apply the ‘Number’ format to the cell.

  • OhNoMoreLemmy@lemmy.ml
    link
    fedilink
    arrow-up
    1
    ·
    3 months ago

    There’s two options, one is to turn it into a string as discussed.

    The other is:

    Format a cell with a number format such as \0000. This format can be assigned in the Format code field under the Format - Cells - Numbers tab, and defines the cell display as “always put a zero first and then the integer, having at least three places, and filled with zeros at the left if less than three digits”.

    https://help.libreoffice.org/latest/en-US/text/scalc/guide/integer_leading_zero.html

    • Flagstaff@programming.devOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      3 months ago

      Thanks, I do know about that but I want to avoid using an escape char because I want to be able to copy the cell without hidden characters entering the clipboard.