NEED HELP 2

J

JJ

Excel has a splendid way of copying your cell if it is repeat information. Is
there any way I can adjust this feature to recognise a number and it will
automatically place the name in the next cell? Thanks.
 
D

Dave Peterson

You could cheat a little bit.

Maybe you could do all your numeric entry like it was text--add a single letter
prefix to your entry:

x1234

Excel will see that as text and help you with the autocomplete.

When you're done with the data entry, select the range and change the x to
nothing:

Edit|Replace
what: x
with: (leave blank)
replace all

Make sure you don't use a character that shouldn't be removed!
 
Top