Dynamic Formula to remove zeros from a specific column

[calvincarr29]

In Asset ID (Tax) column, zeros keep populating in front of the Asset ID which is throwing off a join tool that I have.

How do I write a formula that automatically gets rid of zeros in front of a number (integer)?

 

[alexnajm]

If it was stored as a number, it wouldn't have those leading zeroes!

The function you would use is TRIMLEFT - TrimLeft([Asset ID (Tax)], "0")

[calvincarr29]

It's stored as a number 

[calvincarr29]

Is there a way to do it regardless of data type?

[alexnajm · Accepted solution]

Please show me that it is being stored as a number - I believe what you are saying is impossible and I would like to see. But if you are needing the formula to work with numeric data for some reason, you can add ToString: TrimLeft(ToString([Asset ID (Tax)]), "0")