Forum Discussion
Another issue with Value transformation.
I've played for a couple of days with this, having tried a number of different solutions that worked for others. Cannot figure out how to make a text field convert to value. Here is my XLS. I am runn...
Hi
As shown in D6 your amt contains an additional invisible/unprintable char. (probably due to a copy/paste from the web). To convert it to a number, one way:
=NUMBERVALUE( LEFT( B6, LEN( B6 ) -1 ) )(tried to get rid of the invisible/unprintable char. with CLEAN(B6) - didn't work)