Try the custom number format:

0,," ppm";-0,," ppm";@


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"hmm" wrote in message
...
I have numbers I would like expressed as parts per million (ppm). Just as
%
format displays the number multiplied by 100, ppm format should display
the
number multiplied by 1 million (and append the unit "ppm"). Is there a
way I
can enter this as a custom format, including in charts?

Thanks Chip.

It got the "ppm" part right, but it divides the entered number by a million
instead of multiplying. Also, the number represented by a figure expressed
in ppm is very low; for example, 100 ppm represents 0.0001. When I entered
such values in the cell, it read "0 ppm".

"Chip Pearson" wrote:

Try the custom number format:

0,," ppm";-0,," ppm";@


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"hmm" wrote in message
...
I have numbers I would like expressed as parts per million (ppm). Just as
%
format displays the number multiplied by 100, ppm format should display
the
number multiplied by 1 million (and append the unit "ppm"). Is there a
way I
can enter this as a custom format, including in charts?

Perhaps Chip will come up with something clever but when I was using ppm for
the calculations for the Hydrotherapy pool, I formateed the cell as: General
" ppm"
I then entered - say - 2.5 for 2.5 ppm and divided the cell value by
1,000,000 every time that I use it in a calculation.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"hmm" wrote in message
...
Thanks Chip.

It got the "ppm" part right, but it divides the entered number by a
million
instead of multiplying. Also, the number represented by a figure
expressed
in ppm is very low; for example, 100 ppm represents 0.0001. When I
entered
such values in the cell, it read "0 ppm".

"Chip Pearson" wrote:

Try the custom number format:

0,," ppm";-0,," ppm";@


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"hmm" wrote in message
...
I have numbers I would like expressed as parts per million (ppm). Just
as
%
format displays the number multiplied by 100, ppm format should display
the
number multiplied by 1 million (and append the unit "ppm"). Is there a
way I
can enter this as a custom format, including in charts?