Hi
there are serious issues and inconsistencies using the Drop Down Number Format List and Cell Format Dialog Box.
-Predefined Short, Long Date and Currency formats are displayed in the Drop Down and Cell Format Dialog as “Custom”
-When working with non US (English) cultures, the Format Dialog Box shows in the Locate (location) field English (U.S.)
I enclosed a video to demonstrate the problems. There are a lot of them!
Merry Christmas
Henry