This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Why when converting my Discount and my Net Payment From Payment Request columns from String to Number then cells go to 0.00?
Please ignore/delete the vlookup
This is because of the leading $ sign.
The easiest change is to use a multi field formula tool to remove these.
Should parse all your fields
You need to use a multi-field formula to remove these characters : $ and , and ( and ) and when removing the brackets make sure it's a negative number.
This code will do it:
I'm late to the party on uploading this, but its the $ and ,'s in the numbers.
The attached fixes it.