How to add a leading zero?

[Breezy]

How do I add a leading zero based on the number of digits in my text string? Please see the bottom Frog ID in my example picture.

In my example:

• Every Frog ID must have 9 digits.
• Any Frog ID with fewer than 9 digits needs a 0 added to the beginning of the Frog ID.
• All of Frog ID must be set as text.

Thank you for your assistance

[Saravanan_Desingh]

Try this,

=Text(Num([Frog ID],'000000000'))

[Chanty4u]

try this

repeat('0', (9 - len(Field))) & Field as NewField

[Breezy]

Hi! Forgive my ignorance - does this go in the data load editor?

[jovanTD]

Is there a solution regarding this topic?