I have a field with a numeric value, i need to format it, but the user input different values (same field is used for multiple purpose), so i can have age data, 8, money data, 1.000.000, lead zeros, 012345, and others, all numeric, so i am trying to do a unified number format but doesn't work, some of the format broken or remove lead zeros, so i need your help, this is what i am doing:
Num(Alt([My Value],
Num#([My Value], '#####'),
Num#([My Value], '## ##0'),
Num#([My Value], '####0'),
Num#([My Value], '00000'),
Num#([My Value], '00.000')
))