In article ,
says...

Yep, it works. Thanks, Biff!

Anyone care to enlighten me why it works? I don't understand why the
reference to A1 when the whole range is subject to the format.

Never mind. Looked at the format for various cells within the range and
see how it works now. Thanks to all those who replied (you too Bob!) :-)