Applying direct formatting to spilled arrays in Excel could cause issues if the data changes shape or size. Formula-based ...

so using Excel's built-in number format converter is the way forward. Second, cells containing manually inserted currency symbols could cause problems if the data is extracted to another program.