LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ryan D
 
Posts: n/a
Default Cell Formatting or Borders

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell formatting behaviour question derek Excel Discussion (Misc queries) 3 February 22nd 05 10:17 PM
Paste without including cell borders Heath Excel Worksheet Functions 1 December 29th 04 04:23 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM
conditional formatting blank cell TREK5200 Excel Discussion (Misc queries) 1 December 6th 04 02:23 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"