format as %

[saziz]

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

 

[JakeyC]

Is your formula in a cell?

If so,

<formulalocation>.NumberFormat = "0.00%"

replace <formulalocation> with whatever syntax you want to refer to the
cell (ActiveCell, Selection, Range("A1"), Cells(1,1) etc.)

 

[Guest]

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

 

[Tom Ogilvy]

? format(.2345,"#.0%")
23.4%

 

[saziz]

Thank you Tom, JakeyC & the Student of Gary for help.
It was in a VB code so (#.0%) helped.
Thanks once again
Syed
(I am not even a student sofar...I guess I can be a students'
student.) :