Forum Discussion
Delete all leading zeros in a workbook?
Hi, I need to ask you a question. Are these all texts in the cells where you have leading zeros?
Can your texts be converted into values (for example with the help of VALUE() or in the menu via Text in Columns)? If so, the leading zeros have taken care of themselves.
If it is text and should remain so, it becomes much more complicated. Maybe you can give us some examples. For example with a screenshot.
- I might have figured it out on my own. I targeted all numbers within the workbook and in the "format cell" tab i put "special" "0" = "0;;" and all leading zeros are now gone.
Dont know if this is the correct way to do it but seems like it worked 😃 Thank u for a fast reply!
It seems like the values are texts. I am collecting data on number of employees in a specific region. Since some regions have more employees their columns gets longer and this results in "0" in the other sheets with fewer employees.
So I either need to delete all leading zeros or find a way to just target cells with information within the column across the workbook.
It seems like I dont have permission to post pictures =/
