Formatting cells to display grams

[jamie81]

How do I format cells in Excel to display different weights?

 

[mangesh_yadav]

Examples...?

Mangesh

 

[jamie81]

Grams or Kilos, e.g. g or kg.

 

[JE McGimpsey]

One way:

Format/Cells/Number/Custom 0 \g

or

Format/Cells/Number/Custom 0 \kg

or, if you want both:

Format/Cells/Number/Custom [<1000]0 g_k;0, kg

See "About custom number formats" in XL Help for more.

 

[jamie81]

Thanks. The 0\g works, but can't get the last one to work. Is th
spacing/syntax correct