preset paste values

hi guys

i have alot of data that i copy to a specific workbook
everything i need to paste i want formatted as text
its a real chore keep right clicking - past special - text
is there anyway i can change this to default by pressing ctrl-v ?
thank you

i still have to select text doing it that way

worked it out via macro thanks