Maybe you could try this:

Tools|Options|Edit tab|Move selection after enter|change to Right
Then select your 3 column Range (say A1:C99)
Hit the Number lock key
Use the numbers on the number keypad and when you're done with one cell, hit the
enter key.

It's not quite the same, but it might be a quicker way to enter all your data.

---
Another alternative.
Select a single column (Say A1:A99)
Format that column as Text (format|cells|Number tab|Text)
type your numbers in with no spaces (all 9 digits)

Then use formulas to extract each portion:

=left(a1,3)
=mid(a1,4,4)
=right(a1,2)



mulligbo wrote:

I am working in a spreadsheet where I am transfering numbers from paper. Each
cell has a set amount of digits. For example the first cell is a 3 digit
number. The next a 4 digit number, then a 2 digit number.

Is there anyway I can set it up just like some web pages that have phone
numbers, so that when I input the 3 digit number the cursor jumps to the next
cell, then input the 4 digits, jumps to the next cell and I put in the 2
digit number.

Thanks for the help.

--

Dave Peterson