Display kilograms in grams

G

Guest

I have cells containing numbers of kilograms, but since these are small
amounts, I would like to know if there is a format displaying those numbers
in grams.

For example a cell containing 0.0845 should display "84.5 gr".

Is this possible? Thank you.
 
G

Guest

That's a good idea. Thank you. But I wanted to know if I could avoid changing
the formula, but change the format instead. I know I can display numbers by
thousands or by millions. How about the opposite?
 
R

Ragdyer

If these Kg numbers are results of formulas, can't you just revise the
formulas to multiply by 1000?
 
J

JE McGimpsey

Stefano Gatto said:
That's a good idea. Thank you. But I wanted to know if I could avoid changing
the formula, but change the format instead. I know I can display numbers by
thousands or by millions. How about the opposite?
Click to expand...

No, though you can use scientific or engineering notation if you wish.
 

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

Query based on a combobox on a subform in a subform 3
Format a field in an equation 4
Look-Up Capability 2
display revised total in Office 2003 when cell data changes 1
How to Extract Part Of field Based on Criteria 12
how do you take an answer in a cell and converting it from grams . 3
VLookup 2
Search multiple columns and display corresponding cells in a list?!? 9

Top