This guide will assist you with installing the Spreadsheet Labs Excel Formattic Add-in.
The Excel Formattic custom number format Add-in is provided as a compressed zip file. Follow these steps to install and activate the add-in:
1 – If you have Excel open, close it.
2 – Unzip the file to a location of your choice.
3 – Copy the formattic.xlam file to the Excel add-in folder. If you need to find the location of the add-in folder on your computer, follow these instructions.
4 – The file may be automatically blocked by Windows, which will prevent it from working. To unblock the file, after you have copied it to the add-in folder location, right-click on it, and then select Properties. Make sure you have the General tab of the Properties dialog box active. If there is a Security section at the bottom of the tab, click the Unblock box as seen below. Then click OK.
5 – Open Excel and then click Excel Add-ins on the Developer tab as shown below.
If you can not see the Developer tab, and need help to enable it, click here for instructions to show it.
6 – On the add-in dialog box, click the box beside Formattic to add a check mark beside it. This will add a group to the Excel Home Ribbon entitled “Formattic” as shown below.
7 – If you see the following warning, you will need to click the Enable Content button on the bar.
The Formattic add-in should now be installed and ready for your use.