## Forum Discussion

mmcmanus

2 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