Does anyone have any suggestions on how to set the value?
I would like to convert any number into 4 digit format.
If there is a value 5 in cell A1, then it should return 0005 in cell B1
If there is a value 12 in cell A1, then it should return 0012 in cell B1
If there is a value 684 in cell A1, then it should return 0684 in cell B1
If there is a value 1365 in cell A1, then it should return 1365 in cell B1
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric