| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Type set amount of digits in one cell then automatically move to n
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type set amount of digits in one cell then automatically move to n
See other post.
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Type set amount of digits in one cell then automatically move to n
You have replies at your other thread.
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
| Type info in one cell that automatically repeats in other cells. | Excel Worksheet Functions | |||
| When I type "BVE" in a cell, it automatically chanegs to"BE"..Why | Excel Discussion (Misc queries) | |||
| How to Automatically Move Cell datato adjacent cell.. | Excel Discussion (Misc queries) | |||
| Move automatically to a cell | Excel Discussion (Misc queries) | |||
Linear Mode
