I have a worksheet which is formatted as a list, so that I have the little
filters at the top of each column. It is great, except I cannot get "Custom
Cell Format" to work in it. Are they incompatible?

For example, I have a column of account numbers, which always have 4
numbers, a hypen, and then 5 numbers or letters. I try the custom number
format
XXXX"-"XXXXX
which works outside of the list, but it will not take affect in the list. Is
there anything I can do?