Translations:Faq/Calc/139/6/en

From The Document Foundation Wiki
Jump to: navigation, search
  • Dropdown list
    1. Select the cell or range of cells concerned and go to Data ▸ Validity
    2. On the Criteria tab, and the Allow listbox, choose Cell Range
    3. In the Source box, type TEXT(TODAY();"JJ/MM/AA")