How do I concatenate a 'masked' numeric value in Excel
I have a number cell with a Custom mask of 000, so for example, in cell A3 the value 45 is displayed as 045.
I now want to use that value in a concatenated formula, for example, ="INV"&A3
so that it is displayed as INV045 and not as INV45 as it does currently.
What do I need to add to this formula to display as required ?