I recently downloaded a virtual machine which had all the default factory settings in it - including an American keyboard layout. To change this on Debian Etch I simply used:

dpkg-reconfigure console-data

and then followed the online prompts. For reference (i.e. the next time I have this problem), the | (pipe) symbol on a US keyboard is mapped to the ~ (tilde) on a UK one.