A ppm format
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 |
A ppm format
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? |
A ppm format
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? |
A ppm format
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:) |
A ppm format
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:) |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com