Number Manipulation - adding a space and two zeros at the end
Posted on 2012-04-12
I want to edit a number like this 21 25 00 10 in cell H11.
If the this number is less than 10 digits long (or 14 digits with the spaces), I want to add a space and two zeros at the end of 21 25 00 10 to get 21 25 00 10 00. Then, I want to store the new value in the cell H11 if possible or in another cell if not possible for reference later.
Which function or functions would I use to convert this number from 10 digits to 12 (or from 14 digits to 17 digits with the spaces)?
Thank you for looking at this question