Looking for an alternative vba function for the function CDec which doesn't exist in Excel for Mac.
Any ideas?
Looking for an alternative vba function for the function CDec which doesn't exist in Excel for Mac.
Any ideas?
Do you specifically need CDec rather than say CDbl?
Either would work. What I need to do is convert a string such as "2435678.19237" to 2435678.19
Then you can use CDbl and round the result - use Application.Round unless you want bankers rounding though.
Well don't I feel stupid
Thanks!
Don’t have an account yet? Register yourself now and be a part of our community!