Solved: Removing only 1 leading Zero if there is one.

PeteyG · ‎04-09-2026

Good afternoon.

I originally attempted to trim the Zeros but it trims all the zeros and leaves it blank. I can just trim the 1st character becuase of numbers over 10 and ones that begin with letters. Anyone have tips on If number starts with a zero trim 1 space otherwise ignore?

I have thousands of rows that look a bit like this:

Rev
00
01
02
03
04
10
12
15
A
B
C
D

I need it too look like:

Rev
0
1
2
3
4
10
12
15
A
B
C
D

Juan-Power-bi · ‎04-09-2026

Try this in Power Query as a custom column:
if Text.StartsWith([YourColumn], "0") then Text.RemoveRange([YourColumn], 0, 1) else [YourColumn]
That checks if the value starts with a zero and removes just the first character if so, otherwise leaves it alone. Works fine for "Rev", "A", "10", etc.

View solution in original post

dufoq3 · ‎04-10-2026

Hi @PeteyG, another solution:

Value.FromText([Rev])

Output

Value.FromText([Rev])

Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

Juan-Power-bi · ‎04-09-2026

Try this in Power Query as a custom column:
if Text.StartsWith([YourColumn], "0") then Text.RemoveRange([YourColumn], 0, 1) else [YourColumn]
That checks if the value starts with a zero and removes just the first character if so, otherwise leaves it alone. Works fine for "Rev", "A", "10", etc.