Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to be able to input plain numbers like 200, or 3000 and have the cell display 200g, 3kg, etc... But still be able to add the values in the cells. So if I add the two above I'd get 3.2kg on the result cell.

I suspect this is not possible, but is it?

share|improve this question
I tried but was only able to change the color of the text or the shading of the cell via conditional formatting – mhoran_psprep May 3 '12 at 12:47
I think the answer of pnuts could work out. Have you tried it? – Jacob Jan Tuinstra Mar 14 '14 at 8:26
It depends what you mean by work out. It doesn't address the core of the problem which is automatic unit-consciousness and division. – yarian Mar 14 '14 at 20:54

Does not manage the automatic division by 1000 for kilogrammes but perhaps of some use (better than nothing?)

In New Google Sheets, Format > Number > More Formats > Custom Number Format and Apply:

0,0 g

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.