How to add trailing 00 to a column.

[sriniprad08]

Hi All,

Hope you all doing fine.

i need to create a new field with trailing 00's.

Please find attached

Can you please guide?

Thanks

Sri

[jdminton · Accepted solution]

Those would be leading zeros. Are you looking to just add two zeros in front or do you want to add a certain number of zeros to get to six digits? For the first, use "00" + [Field]. For the latter, use Padleft([Field],6,"0")

[binu_acs · Accepted solution]

@sriniprad08 

[sriniprad08]

Thank you @binu_acs . appreciate it.

[sriniprad08]

Thank you @jdminton . Appreciate that.