How to replace with leading zeros in Excel?
In an Excel file, I need to replace, say, "foo" by "007".
I selected all the file and I explicitly put the cell format to be in Text mode.
So, why it replaces me "foo" by "7" and not by "007" as I said it :( ?
Solution 1:
Apparently, excel interprets "007" as number when replacing. So you could use '007 in the replace-dialog, so it shows your wanted result.
Solution 2:
Just put a single quote in front of your leading number - ex. '01234 It will take the number as-is literally and the quote will not show in the field.