I think I'd do each 5 digit number in its own cell (especially if they're gonna
be in different rows (same column)).
Then after I was done, I'd separate them into individual cells.
I'd use Data|Text to columns
Fixed width
draw a line after each digit
and finish up.
You could even use formulas if you want (and still enter your 5 digit numbers in
column A):
Put this in B1 and drag to F1:
=MID($A1,COLUMN()-1,1)
then drag down.
If your numbers may have leading 0's, use this formula:
=MID(TEXT($A1,"00000"),COLUMN()-1,1)
Ryan D wrote:
How do I input a 5-digit number into Excel so that they are in separate boxes
on the same line, but I don't have to press "Tab" each time to move to the
next box?
For example what I have right now is the number 53421, with subnumber "5" in
the first cell, subnumber "3" in the second cell, etc. Each time I enter one
of these 5-digit numbers I have to hit tab after each subnumber--which means
hitting tab 5 times for each number. This is a bit inconvenient when
entering many numbers.
It doesn't matter to me if this number is all in the same cell or different
cells. But I want to keep the gridlines so that each subnumber is in it's
own box on the same line. This should be really simple, but I can't figure
it out. Any ideas? Thanks.
--
Dave Peterson
|