I have created label print solution, where single row data of 12 cells is converted into 5 rows printable label for collection items.
Printout is 10 labels on A4 sheet.
That means I copy 10 rows and I receive new sheet of 10 printable labels.
Now the problem is currency format.
When in a row the original cell has $ format, then target cell inherits $ format.
But now this target cell remains "forever" $ and when I copy a new row for printout with cell in £ format, it remains $ in target cell, instead of £.
There is a formula in target (label) cell =+L3*1.2.
Any ideas how to force target cell to update currency format?
Shift+F9 doesn't fix this.
Printout is 10 labels on A4 sheet.
That means I copy 10 rows and I receive new sheet of 10 printable labels.
Now the problem is currency format.
When in a row the original cell has $ format, then target cell inherits $ format.
But now this target cell remains "forever" $ and when I copy a new row for printout with cell in £ format, it remains $ in target cell, instead of £.
There is a formula in target (label) cell =+L3*1.2.
Any ideas how to force target cell to update currency format?
Shift+F9 doesn't fix this.