Looking to migrate some old Lotus .123 files to Excel - we name ranges using column Headers that contain special characters ( eg GDPn$_g, GDPn£_g, IBUS%_k ) as we work with column data expressed in many different currencies & ratios in same sheet - hence the need for "$", "£" and "%" etc in the RangeNames/Column Headers to distinguish the distinct currency demoninations.
But Excel (or Libre/AOO Calc) won't seem to allow this (?). Is there an Excel workaround or hack that would enable SCs ? eg somehow "escape" the SCs in the RangeNames - its a big deal for our "global data" spreadsheets ? (Any prospects/news on opening .123 files in (future) Excel releases ? ..or any custom routes ? )
Any thoughts/pointers appreciated
But Excel (or Libre/AOO Calc) won't seem to allow this (?). Is there an Excel workaround or hack that would enable SCs ? eg somehow "escape" the SCs in the RangeNames - its a big deal for our "global data" spreadsheets ? (Any prospects/news on opening .123 files in (future) Excel releases ? ..or any custom routes ? )
Any thoughts/pointers appreciated