I converted an involved spreadsheet with lots of named ranges and programming
from 2003 xls to 2007 xlsm. In the process it added an underscore to the
front of some of the names (that ended in a number) but not all. It was
consistent for similar names (rpt01, rpt02, etc changed to _rpt01, _rpt02,
etc) but the majority of other names were not changed, including some that
also ended in a number. Can anyone tell my why it does this?