If the answer to a formula is 123.45 and I want to then break that number up
so that each digit goes into a different cell....

ie.... 1 goes in one cell, 2 goes in the next cell, 3 goes in the next
cell, I can skip the decimal, 4 goes in the next cell and 5 goes in the last
cell.

What I am trying to do is take the answer to the formula and make it appear
on a printed form with each digit in a separate box......

Also, my answer might be in the thousands or only in the hundreds, what will
appear in the emply boxes. I have attempted using (right) and (left) but I
don't know how to pick only one number. and i don't know what to do with the
empty boxes. Any help would be appreciated.....

Thanks Linda H.