To format percentages, go to FormatCells...Percent

If you need a formula then explain what % you're looking for. It could be
as simple as dividing one number by another

=A1/B1
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"princess" wrote in message
...
hey how do u do percentages in excel