View original (French)

Lock Excel date format

Solved
meli_melo13 Posted messages 8 Status Member -  
meli_melo13 Posted messages 8 Status Member -
Hello,

I am looking to lock cells in an Excel file of the type .../.../... so that users cannot enter anything other than a date.

Thank you for your quick response as this is a professional issue.

Configuration: Windows XP / Firefox 3.6.8

1 answer

  1.
    pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
     
    Hello,
    Data/Validation
    Choose "Allow": "Date"
    Then make your selection according to the dates to be entered...
    Example:
    "Data": greater than
    "Start date": 01/01/1900
    --
    Best regards,
    -- Every problem has its solution. If there is no solution, where is the problem? --
    2
    1. meli_melo13 Posted messages 8 Status Member
       
      Thank you for the solution, but is it possible to show the slashes, for example ../../.... so that people understand how to fill in the box.
      Thank you for your help.
      0
    3. meli_melo13 Posted messages 8 Status Member
       
      ok thank you very much
      0