Other Issues

Ribbon Buttons Are Greyed Out

Are you editing an Excel cell? Excelerator disables most ribbon buttons when Excel is in edit mode. Hitting Esc should end the edit.

Have you opened the Designer? Excelerator disables some ribbon buttons when the Designer is open.

Leading Zeros Stripped in Excelerator Ranges

In Excel, leading zeros are stripped from cells by default. This means that if you enter a number with leading zeros, such as "00123", Excel will automatically remove the zeros and display the number as "123". This behaviour is because Excel treats numbers with leading zeros as numeric values and numeric values do not have leading zeros.

If you want to preserve the leading zeros in Excel cells, you can format the cells as text before entering the values. To do this, you can select the cells, right-click, choose "Format Cells", select "Text" under the Number tab, and then click OK. This will ensure that any values you enter in those cells, including ones with leading zeros, will be treated as text, and the leading zeros will be preserved.

Setting the "Add Excel format" option before you design templates can resolve this issue. You can also reformat ranges in Excel.

To learn more about this feature, please refer to the Add Excel Format To Range section in the documentation.

This shows the issue before and after the "Add Excel Format To Range" is ticked.