How do I remove zeros in front of a number in excel?
- 1 Answers
- 731 Views
- I also Faced
- E-Mail Answers
Answer Posted / Brajesh Kumar
To remove leading zeros from numbers, you can use the TRIM function (available in Excel 365 and later) or custom formulas. The TRIM function removes leading spaces but also works for leading zeros.nnFor custom formulas, use: =RIGHT(A1, LEN(A1)-FIND(".", A1, FIND(".", A1, FIND(".", A1, 1) - 1) + 1)). This formula removes everything before the decimal point and leaves only the non-leading digits.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
