Forum Discussion
Delete all leading zeros in a workbook?
Hi! Im working with a lot of data in excel using around 200 sheets. I know how to delete all leading zeros using either options menu är kutools on a single sheet. But how to I do this for the who...
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 😃
Dont know if this is the correct way to do it but seems like it worked 😃