Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display kilograms in grams
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. -- Stefano Gatto |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display kilograms in grams
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? -- Stefano Gatto "Ragdyer" wrote: If these Kg numbers are results of formulas, can't you just revise the formulas to multiply by 1000? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Stefano Gatto" wrote in message ... 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. -- Stefano Gatto |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display kilograms in grams
If these Kg numbers are results of formulas, can't you just revise the
formulas to multiply by 1000? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Stefano Gatto" wrote in message ... 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. -- Stefano Gatto |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display kilograms in grams
In article ,
Stefano Gatto wrote: 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? No, though you can use scientific or engineering notation if you wish. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a formula to convert kilograms to pounds | Excel Worksheet Functions | |||
How do I convert kilograms to ounces in excel? | Excel Worksheet Functions | |||
lbs ounces grams | Excel Worksheet Functions | |||
Problems with "hyster-grams" :-) | Excel Discussion (Misc queries) | |||
Spider Grams | Excel Discussion (Misc queries) |