Earlier today I had a problem with a formula.
The solution was making sure my original 3 digit input was a number format instead of a text format (why because some numbers that were inputted started with a "0" which a "general" format wouldn't pick up).
So I added a "000" to my "custom" format and it seems to solve the previous problem.
Now as I try to break out any "new" inputted numbers as you'll notice in row 20 of my sample file of 052 works but in Columns B, C, D when I try to break out the number individually the "0" is dropped and the last 2 numbers "slide" over?????
You might say in prior numbers there were "0" in the first position - those number existed, the problem happens with any "NEWLY" inputted numbers.
B20 coding: =IFERROR(MID($A20,COLUMNS($A$3:A$3),1)+0,"")
C20 coding: =IFERROR(MID($A20,COLUMNS($A$3:B$3),1)+0,"")
D20 coding: =IFERROR(MID($A20,COLUMNS($A$3:C$3),1)+0,"")
See attached sample.
And any suggestions???
Bookmarks