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?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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?

As I feared, thanks
Excel lets you format rounding to thousands and millions; lets you scale
chart axes likewise. But factors less than 1 are not provided for. Pity!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JE McGimpsey" wrote in message
...
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?

On Feb 13, 10:25 am, "Bernard Liengme"
wrote:
As I feared, thanks
Excel lets you format rounding to thousands and millions; lets you scale
chart axes likewise. But factors less than 1 are not provided for. Pity!
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email

"JE McGimpsey" wrote in message

...



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?- Hide quoted text -

- Show quoted text -

Consider hiding the column of your results containing 0.000005 and
just having a second column to the right saying =A1*1000000&" ppm"

Simple enough:)

Yes, I use this but it need one more step. One can do per cent directly, why
not per million?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"S Davis" wrote in message
ups.com...
On Feb 13, 10:25 am, "Bernard Liengme"
wrote:
As I feared, thanks
Excel lets you format rounding to thousands and millions; lets you scale
chart axes likewise. But factors less than 1 are not provided for. Pity!
--
Bernard V Liengmewww.stfx.ca/people/bliengme
remove caps from email

"JE McGimpsey" wrote in message

...



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?- Hide quoted text -

- Show quoted text -

Consider hiding the column of your results containing 0.000005 and
just having a second column to the right saying =A1*1000000&" ppm"

Simple enough:)