I typed three semicolons into Excel and found its strangest formatting trick

I typed three semicolons into Excel and found its strangest formatting trick
https://www.makeuseof.com/typed-three-semicolons-into-excel-found-strangest-formatting-trick/

  • A custom number format has four slots
    Leave every one of them empty, and Excel draws nothing
  • Formulas still read the hidden value
    Blanking the display never touches the data underneath
  • This beats hiding columns or turning the font white
    Both of the obvious workarounds fail in ways this one does not
  • It hides the number, but it does not hide much else
    Where three semicolons stop being enough
  • Where I would take this next
    The display layer is worth using on purpose