If you want to keep source formatting for the majority of columns, leave the Keep Source Formats box checked for the table as a whole and proceed as follows:
- Expand the table node by clicking on the '+' to its left
- Right click on the node for the column you want to apply Excel formatting to
- Select Properties
- Deselect the Keep Source Formats box and click on OK at the bottom of the Properties dialog window
- Click on the Toolbar icon to open the Excel tool ribbon, here you can see the Excel tool ribbon already visible, and apply the formatting you want
This will cause the content for all cells in the selected column of the table to be exported from QlikView without formatting and you can apply formatting from the Excel tool ribbon. You can do this for as many individual columns as you need.