J
jamie81
How do I format cells in Excel to display different weights?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
mangesh_yadav
Examples...?
Mangesh
Mangesh
J
jamie81
Grams or Kilos, e.g. g or kg.
J
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.
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.
J
jamie81
Thanks. The 0\g works, but can't get the last one to work. Is th
spacing/syntax correct
spacing/syntax correct