Writing a function in VBA to take a number and add a one in front of it, so =addone(50) returns 150, =addone(2300) returns 12300.
EDIT: I forgot to check for negative numbers. Log10 also doesn't work on negatives, but added a few extra lines to turn -23 into -123
Code sample at vbaforbusypeople.nice1up.com
LIKE AND SUBSCRIBE
