Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Maybe a silly question, but I have difficulties conversing the below data to numeric data using NUm# or NUm .
000000000000150 |
000000000000354 |
000000000000558 |
000000000000572 |
000000000000600 |
The above should translate in numeric , resp
150
354
558
672
600
I used num#(fieldname,'XXX') but that doesn't do the job and even tried changing the settings (no decimal sign or thousands seperator)
Guess solution might be simple ... just don't seem to find it 😉
Since the numbers have more than 14 digits, they are problematic to interpret using Num#(). But you can do it with Evaluate():
Num(Evaluate(fieldname))
Since the numbers have more than 14 digits, they are problematic to interpret using Num#(). But you can do it with Evaluate():
Num(Evaluate(fieldname))
Thanks Henric this fixex my puzzle indeed
You saved me quite some investigation time 😉