AFAIK, there's no way to do this - % is hard-coded.

VBA can only apply valid cell formats to cells. The display engine is
independent of VBA.


In article ,
"Bernard Liengme" wrote:

Is it possible in VBA to make a sub that formats a cell?
I would like to have 0.000005 displayed as 5.00 ppm but I want the value to
remain unchanged.
I guess I am asking how Excel makes .05 display as 5%
Does VBA has access to the 'layer' that displays as opposed to the 'layer'
that stores?