How do I convert a string in scientific notation to real without rounding it. e.g, I want to convert 1.79185E-05 to 0.0000179185. Using Val("1.79185E-05") converts it to 0.00002 and I am not looking for a rounded number, I want the exact number in real, any ideas?
Thanks Rakesh for the info, you saved me some time, I was going to create a custom function to convert scientific notation to real. The above function is the answer to my problem, for anyone else interested if you use PrintftoString you will get the value in a string.