MS Access / Excel

[( |-| |2 ][ $]

I've got a table of codes like this:
666
15
15
704

and I need excel or access to automatically convert the data into the full codes like this:
EUK00666
EUK00015
EUK00015
EUK00704

Some sort of autocomplete option that works backwards, or a macro I could run that would update them all?

Any help will be much appreciated.

 

[( |-| |2 ][ $]

Yes that works great thanks. I wonder if I can push my luck and ask for a last question.

converting numbers stored like this:

6.6.07
18.6.07

into date format 06/06/2007?