I'm using several hierarchy type custom settings in an application.  When upload the package in as UNMANAGED, all is fine.  However, when I try to install the package, I get an error.  I tried to install the contents of the same package using the Force.com IDE, it errors out.  I am able to trace the errors to references to the custom settings in the formulas.  These references show the namespace prefix from the source package.  I would presume once I convert this to a managed package, I will not get these errors.  However, I also need to install it an unmanaged.

Does anyone know how to remove references to the namespace prefixes for custom settings in a formula?  I have tried to edit the formula directly from the Force.com IDE.  When I save, the namespaces are automatically put back in.  I am beginning to believe that I will have to remove ALL the formulas and apply the changes manually.