D
D
I'd like to be able to take a 5,6,7 digit number and
adjust it according to certain rules. If the number is 5
digits I'd like it to return the Leftmost number (=Left
(cell reference,1) if it's 6 digits I'd like it to return
the Leftmost 2 numbers and if it's 7 digits I'd like it to
return the leftmost 3 numbers. I've been messing around
w/ it for awhile and don't seem to be able to get my "if"
statements correct. Perhaps I'm going about it all
wrong. Any help would be greatly appreciated, thx
beforehand!
F
adjust it according to certain rules. If the number is 5
digits I'd like it to return the Leftmost number (=Left
(cell reference,1) if it's 6 digits I'd like it to return
the Leftmost 2 numbers and if it's 7 digits I'd like it to
return the leftmost 3 numbers. I've been messing around
w/ it for awhile and don't seem to be able to get my "if"
statements correct. Perhaps I'm going about it all
wrong. Any help would be greatly appreciated, thx
beforehand!
F