Today I heard from someone who was having problems with data validation, in cells that were formatted in Percent Style. In the workbook, Enable automatic percent entry is turned on (Office button, Excel Options, Advanced, Editing options).

In the cells that are formatted as Percent Style, the percent sign automatically appears as [...]