In previous versions of excel I was able to format the contents of a cell by using Format() (ex. Format(A1.Value, "0.00%") to turn the value of cell a1 into a percentage. But in the 2007 version of excel I get an error that the project or library cannot be found. Does anyone know which reference I should add to get this to work?

thanks