Hi Dave,

FormatCellsNumberPercentage, choose the number of decimal places.

BTW it doesn't round, it just doesn't show all the digits. Try calculating
with it (1 year's interest) and you'll see it has more digits than it shows.

--
Kind regards,

Niek Otten

"Dave Roberts" wrote in message
oups.com...
Niek,

Thank you. I notice that this seems to round to the nearest
percentage, how can I get the result accurate to two decimal places
(i.e., 7.05% vs. 7%)

Thanks,
Dave