Formatting cells to display grams

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.
 
J

jamie81

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Definition dynamic minverse 0
Printing Outline view - formatting lost 0
Excel does not accept text format! 0
grams to pounds formula 0
Confused,simple math formula 1
Calculating perfect combination of numbers to end up as close to 1700.0as possible 3
Descenders clipped 0
Paste to excel from word - auto format problem 1

Top