Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 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 at 20:54
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.