Removing only 1 leading Zero if there is one.

[PeteyG]

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

[dufoq3]

Hi @PeteyG, another solution:

Value.FromText([Rev])

Output

Value.FromText([Rev])

[Juan-Power-bi · Accepted solution]

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.

[PeteyG]

Fantastic!  Thank you!