2] Format cells as text. The next method you can use to prevent the removal of leading zeros in Excel is to format the target cells as Text. When done that way, the number will be displayed as you ...

Place your cursor on cell C5 and type the following function: =TRIM(A5) The above function will remove all unwanted spaces from the text string in cell A5 and display the result in cell C5.

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.