Quote Originally Posted by protonLeah View Post
With 12345 in cell A1, the formula gives m: 15. Did you remember to adjust the A1 to reflect the actual cell you are using? Did you "Ctrl+Shift+Enter", not just enter after typing the formula?
Yes and yes... still I get an error in formula

The new formula gives me an error as well. What am I doing wrong