G

#### Guest

is what I have:

B C D E F G H I J K L M N

9 0 SPACE 5 0 0 0 4 2 1 =+b =+C =mod(a formula)

Result:

B C D E F G H I J K L M N

9 0 5 0 0 0 4 2 1 9 0 2

I need the values of E through N to be in one cell.

I also need to be able to do the reverse:

If I put a 10 digit number in one cell, I need to be able to put each number

in a separate cell, all in the same spreadsheet.

Any sugestions would be helpful. I have tried to concatenate; however, I

think it does not work because it is for text only. I am unable to reveal

the mod check formula, so even if I can get the first 9 numbers in the field

and have to manually change the number, that would work also.

Thanks in advance for any help.