Excel: Changing number format to grams or litres

[Peder]

hi Everyone

I want to change the number format in excel to Grams or litres so lets say i want something to be 70grams i put in 70 and it appends the g so that i can do a formula with the 70 and not the g.

Is that possible?

Thanx
Peder

 

[gifs]

You do this:

Format Cell
Number
Choose "Custom"
Select a format you want (eg. 0.00)
Then just add "g" to it so it looks like 0.00"g"

and voila!

 

[Peder]

thanx gifs!!!!