| ♥ 0 |
Hi Pete, I found RTD (%Change) was formatted in text rather than a number. How to change it into number? Thanks. RESOLVED
Marked as spam
|
|
Private answer
Hi Pete, because I couldn’t sort them in a sequence, it might be caused by iferror() I added in front of RTD. I will do a test. And let you know later. Thank you. Have a good weekend :-)! Marked as spam
 Posted by jx2012 (Questions: 7, Answers: 9) Answered on September 2, 2017 3:14 am
|
Please explain why this is relevant (what do you gain by changing the format?). When I export a watchlist with this column it is formatted as “General”. Seems to display exactly the same as it does in the watchlist on TOS. And when I apply this column in a formula it treats the value as a number. Everything appears to be functional.