Hi there,

I am trying to create custom cell formats in Excel 2003 for Ohms (including
KΩ and MΩ) but not having much success!! Would also be useful to create
formats for Farads (including uF, nF, pF) and inductance. I am having to set
the cells up as text which means I cannot use formulas to include the figures
in those cells.

Any help on this matter would be greatly appreciated!

Many thanks

On Tue, 15 Feb 2005 06:03:02 -0800, "GlanzaV"
wrote:

Hi there,

I am trying to create custom cell formats in Excel 2003 for Ohms (including
K? and M?) but not having much success!! Would also be useful to create
formats for Farads (including uF, nF, pF) and inductance. I am having to set
the cells up as text which means I cannot use formulas to include the figures
in those cells.

Any help on this matter would be greatly appreciated!

Many thanks

You could use a custom format similar to:

[<1000]0?;[<1000000]0,K?;0,,\M?

In the above, the '?' represents the Omega or Ohm sign. You can enter that
into the custom format box by using charmap (Start/Run and type charmap into
the box; then select advanced view and search for Ohm; copy it; then paste it
into the Excel format cell box).

You may or may not want to add decimal points to the above format.
--ron