Num Formatting

[mario-sarkis]

Dear ALL,

I need to transform an number '002' to 2

I have a field Branch code looks like '002' or '014' or '051' I need to transform it as 2,14,51

I tired num([Branch Code]) & num#([Branch Code]) it didn't work it still giving me '002' or '014' or '051'

hope that you can help with this I need to transform the above field in the script.

thank you,

[sunny_talwar]

Can you try this

[Branch Code] * 1 as [Branch Code]

[m_woolf]

num# should work. Does your field have any leading or trailing spaces? Maybe:

num#(trim([Branch Code]))

[sunny_talwar · Accepted solution]

May be a over-arching Num() is needed after Num#()

Num(Num#([Branch Code]))

Because Num#() only helps to interpret, but the change will need Num(), right?