Sometimes we need to show the numbers in Units of Measure (e.g., KG, LB, KMS, CM … etc)
Generally people do this by using Text function but after this, the Number gets converted to Text and it create issues while doing calculations. So to avoid this and still showing the numbers in units, follow the below process:-
1. Select the numbers which you want to show in Units of Measurement
2. Right click and choose “Format Cells” option
3. In the format cells window, go to Number tab and click “Custom” in the category
4. In the type field, enter following:-
5. Click OK
You can change the “KMs” to other measurement units of your choice.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.