Forum Discussion
mmcmanus
8 months agoQrew Member
In case anyone was interested in updates to a 6 year old post, I just discovered that Quickbase can interpret scientific notation within the ToNumber() function now. Using Dan's solution below as an example:
var number base = ToNumber(Left([input],"^")); var number zeroes = ToNumber(Right([input],"^")); $base*(10^$zeroes)
Simplifies to:
var number conversion = ToNumber([input]); $conversion