Iterations in Microsoft Excel templates do not resolve constant number or functions in cells

Iterations in Microsoft Excel templates do not resolve constant number or functions in cells unless the numbers or functions are formatted as Text but then their functionality it's useless.

Please find attached some example of templates where this scenario is shown.