Or u can use following formula also,
in a2 cell
=INT(A1/10000000)
in a3 cell
=INT(A2/1000000)-B2*10
in a4 cell
=INT(A2/100000)-B2*100-C2*10
like wise.
This may be more useful incase digit is number
Regards.
"Biff" wrote:
Hi!
Insert a helper column to the left of the eight other
columns.
Assume that is column A and you enter this one 8 digit
number in A2.
A2 = 12345678
In B2 enter this formula and copy across to I2:
=--MID($A2,COLUMN(A:A),1)
Biff
-----Original Message-----
I need to enter an 8 digit number, with one number per
cell. It gets old
having to hit a number, then the tab, then the
number...you get my drift. Is
there anyway to set up a formula or something so that
after I enter the one
number, it automatically jumps to the next cell, etc? (I
used to be able to
set up a skip field on the old keypunch machines
programming. Surely there is
some way I can do this in Excel.
.
|