Shopcode stored as text, need to be number

[#1]

Hey guys, I have a field (Shopcode) that comes from Salesforce. The thing is that it comes stored as text, but i need it to be stored as a number, so it will be recognized as the same shopcode of my other database. how do I change that? I tryed 'num([Shop Code])', but it didn't work. Is there anyone who can tell me?

thank you

[hic · Accepted solution]

Num#([Shop Code])

... but used with a proper format code.

HIC

[#3]

Try using Text() function

[CELAMBARASAN]

Try with Num# function

if [Shop Code] is like '12345'

Num#([Shop Code])

if it has values like '123,456' Then use formatting

Num#([Shop Code], '#,###')