Type 3 digits in one cell then automatically move to next cell.
 

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.

Type 3 digits in one cell then automatically move to next cell.
 

No. You have to hit some key to let Excel know you're done typing in a cell.
Those keys a Enter, Tab, one of the directional arrow keys or ESC.. Until
you hit one of those keys Excel is in Edit mode and nothing else can happen
until you are out of Edit mode.

Biff

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

Type 3 digits in one cell then automatically move to next cell.
 

No. You have to hit some key to let Excel know you're done typing in a
cell. Those keys a Enter, Tab, one of the directional arrow keys or
ESC..

In addition, you can use your mouse to click on another cell.

Biff

"Biff" wrote in message
...
No. You have to hit some key to let Excel know you're done typing in a
cell. Those keys a Enter, Tab, one of the directional arrow keys or
ESC.. Until you hit one of those keys Excel is in Edit mode and nothing
else can happen until you are out of Edit mode.

Biff

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

Type 3 digits in one cell then automatically move to next cell.
 

I don't believe this is possible. One thing you could do however, is enter
all numbers for each line into one cell. Then, when you're done, use
"Text-To-Columns" to seperate the numbers into their appropriate cells.

HTH,
Elkar


"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.

Type 3 digits in one cell then automatically move to next cell.
 

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