How to remove leading zeros in text but specially for numbers only

[Anonymous]

Dear all,

I tried to remove leading zeros in my power query by converting the data type from text to whole number. However, i received error for those data which are not really numbers. Therefore, could you please help me out with the solutions.

Data		Expected Result
0000000023		23
0000000024		24
0000000025		25
0000000026		26
0000000027		27
0000000028		28
0000000029		29
A123456		A123456
B574785		B574785

Best regards & Many thanks

[stageja]

It does not work in direct query

[wdx223_Daniel · Accepted solution]

NewStep=Table.AddColumn(PreviousStepName,"Expected Result",each Text.TrimStart(Text.From([Data]),"0"))

[sevenhills]

Since it is already text data, we can use directly

each Text.TrimStart([Data], "0")