This is caused by your user losing either Full control or ownership of the profile folder - windows then creates the next logical filename (because it can't create another folder with the same name).
Two ways around this.
1. If you use roaming profiles - log on as an admin,
start --> run -->
sysdm.cpl go to advanced --> userprofiles and select the user profile(s) in question (the user may be listed twice) select delete.
Go to %systemroot%\documents and settings and make sure that there are no profiles there for the user in question (if there are, delete them - they are not registered anyway!) Log the user back on - job done
2. If you are using local profiles - log on as an admin.
Grant the user ownership of the folder, ticking the "replace owner on subcontainers" checkbox and close properties. Open properties again and grant the user full control of the folder (if he/she doesn't already have it) - in the advanced section, select "replace permission entries..." and apply.
Open regedit and go to:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\ProfileList
Locate your user profile folder.
You will see several folders named according to the user SIDs - not according to the user names. The easiest way to find the profile in question is highlight the above mentioned key and press ctrl + f - then search for the username.
Once you find the relevent sub-key folder, double-click the
ProfileImagePath value and add the path to the original profile.
You can now delete <username>.000