Hello everyone,
I have products with different weights such as" ml, kg, L,...etc. And I'd like when I write the weight: ml or kg, in the cell to give me the exact weight.
For example:
In the cell i would write: 50 ml or 50 kg. I want my cell to give me the "ml" or "kg".
I tried in the "Custom" from the "Format Cells" menu under the "Number" tab to write the following:
0" kg". But this will only give me "kg". If I choose another weight such as: "ml", it won't come.
Hope the above is clear.
Thanks in advance for your help.
Marwan
I have products with different weights such as" ml, kg, L,...etc. And I'd like when I write the weight: ml or kg, in the cell to give me the exact weight.
For example:
In the cell i would write: 50 ml or 50 kg. I want my cell to give me the "ml" or "kg".
I tried in the "Custom" from the "Format Cells" menu under the "Number" tab to write the following:
0" kg". But this will only give me "kg". If I choose another weight such as: "ml", it won't come.
Hope the above is clear.
Thanks in advance for your help.
Marwan