Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Correcting and Auto Filling Cells
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filling cells from another sheet | Excel Discussion (Misc queries) | |||
Auto filling cells in a column | Excel Discussion (Misc queries) | |||
HSI in data cell is auto correcting to HIS | Excel Discussion (Misc queries) | |||
Auto filling cells across mutliple sheets | Excel Discussion (Misc queries) | |||
Auto Protecting cells & auto filling date | Excel Discussion (Misc queries) |