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.

The Format Painter in Excel lets you copy formatting from one ... Cell formatting includes everything from font size and ...