Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! JJ wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|