Number is in A1
In B1 (for thousands) =IF(A11000,INT(A1/1000),"")
In C1 (for hundreds) =IF(A1100,INT(MOD(A1,1000)/100),"")
In D1 (for tens) =IF(A110,INT(MOD(A1,100)/10),"")
In E1 (for units) =IF(A1=1,INT(MOD(A1,10)),"")
In F1 (for first decimal) =INT(MOD(A1,1)*10)
In G1 (second decimal) =INT(MOD(A1,1)*100)-10*F1
I expect there a few dozen other math ops to do this!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Linda H." <Linda wrote in message
...
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.