PC Review


Reply
Thread Tools Rate Thread

Auto Correcting and Auto Filling Cells

 
 
Arnold
Guest
Posts: n/a
 
      27th Feb 2008
Hi; if users press the number 4 and then Tab, Enter, or Arrow, how can
Excel auto-fill the cell as "444." However, if users manually key the
complete 3-digit combination 444, Excel should retain "444."
Similarly, if users accidentally type four or more 4s (4444), how can
Excel correct this and change the cell to "444."

Currently, cells in this range are validated through a v-ref list--can
accept 0, 111, 222, 333, 444, and all possible 3-digit combinations of
the numbers 1, 2, 3, and 4.

THANKS!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-filling cells from another sheet RichW Microsoft Excel Misc 1 28th Oct 2008 07:43 PM
Auto filling cells in a column =?Utf-8?B?QWxleA==?= Microsoft Excel Misc 7 16th Oct 2007 02:46 PM
Auto Protecting cells & auto filling date ccarmock Microsoft Excel Misc 7 30th Sep 2005 09:21 PM
Auto filling in adjacent cells JPA888 Microsoft Excel Misc 5 29th Oct 2004 09:20 PM
Another question on Auto Filling Cells =?Utf-8?B?SiBQb3dlcnM=?= Microsoft Excel Misc 7 27th Sep 2004 12:25 PM


Features
 

Advertising
 

Newsgroups
 


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