The attached should be doing what you need.
I added a column (column E) to the SYMBOLS section of the MasterData sheet which shows the type of number format for any particular symbol- you'll obviously need to check that these are updated.
When you change column E on the Trades-Master sheet, the applicable formatting will be automatically applied to the relevant cells.
Bookmarks