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
>
>