Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Num#([Shop Code])
... but used with a proper format code.
HIC
Try using Text() function
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], '#,###')