Remove leading zeros

David Paras

• June 02, 2014 21:32

Is there an easy way to remove leading zeros?

Example:
00001234501

I need:
1234501

I can't use Translate because it will catch the zero at the end.

Is there a leading trim function?

1

• 

  David Paras

  • June 02, 2014 21:32

  You can use the number function (Math)

  number( '00001234501')

  0

Post is closed for comments.