Thread
:
AUTO COMPLETE NUMBERS
View Single Post
#
6
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
AUTO COMPLETE NUMBERS
Data|Validation doesn't offer autocomplete, but it would allow choosing from a
dropdown.
Bruce Sinclair wrote:
In article ,
wrote:
Tell you'r department head to use a prefix of A while entering the data. Then
when the data entry is finished, it's just:
Select the range
edit|replace
what: A
with: (leave blank)
replace all
If you use an apostrophe, then this technique won't work.
Could you not use data validation to do this ? ... assuming that there are
only a few numbers involved of course. :) Sounds like it's job codes or
something similar. If you can list em, you could get em into a drop down box
and just pick the right one.
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson