Two different choises, suppose your number is 0.15:

1. Click on the cell, pull-down Format Cell Number Percentage
cell will now show as 13.00%

2. If your number is 15, click on cell, pull-down Format Cell Number
Custom

and enter General" %"
--
Gary's Student


"saziz" wrote:


Hi All,
What would be the syntax for format(my formula,"percent")?
Help appreciated
Thanks
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=477349