- In short
- Adds leading zeros to a fixed width (e.g. 42 → 00042) or removes them, for tidy codes and IDs. In-place edits (+ text format when storing as text). The source table is left as it is; Undo Last brings it back if needed. The whole operation happens locally; nothing is sent anywhere.
What it is for
Leading Zeros is used to add or remove leading zeros to a fixed width.
When to use it
Most useful when you need to pad product/account codes to a fixed length (e.g. 00123).
Example scenarios
- Pad product/account codes to a fixed length (e.g. 00123).
What it needs
A range and an options dialog (mode/width/store-as-text); merged rejected. Supported data types: text, number, date (by selection).
How to use it
- Select the range to convert.
- Run Leading Zeros from the Text & Numbers group on the XLMind Data tab.
- Pick the settings you need in the window that opens.
- Confirm; in-place edits (+ text format when storing as text).
What it produces
In-place edits (+ text format when storing as text).
Effect on your data and undo
Leading Zeros writes the result over the cells you selected. One click on Undo Last brings everything back.
How it differs from similar tools
Where manual cleanup goes cell by cell, this runs one complete pass and leaves a single, fully reversible change behind.
Good to know
Merged cells rejected.
Limitations
Merged cells rejected.
Frequently asked questions
- Where will I see the result?
- In-place edits (+ text format when storing as text).
- Are formulas affected?
- Formulas skipped.
- How are blank cells handled?
- Empty text skipped.
- Can I undo the operation?
- Yes. Undo Last on the ribbon reverses it in a single step.
- Does the result stay linked to the source?
- The output does not track the source afterwards; a quick rerun brings it up to date.
- Any known limits?
- Merged cells rejected.
Works well with
- To tidy the data first, use Fix Apostrophe Numbers
- To keep working on the result, use Formulas to Values
- Often used alongside this tool: Text to Numbers
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.