Thanks, Greg. I was thinking that all the "auto format as you type" lines were probably unnecessary. In any case, both macros work.