Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback