Custom Number format showing units.

  • Thread starter Thread starter GrahamS
  • Start date Start date
G

GrahamS

I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?
 
GrahamS said:
I want to do a calculation multiplying 2 cells with the result to show in a
3rd cell as: ###.## kg. How do I get the kg to appear?
Click to expand...


I think this is what you need

=A1*B1&" kg"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to create a calculated item based on a calculated field 1
Custom a number - Excel 2007 with Vista OS 14
How do I format a cell value to show kg? 2
Custom format string from cell value 2
Inseart row if cell number is repeating 2
Calculating with 2 different formats 3
How to records that the date field = todays date in VBA 2
Formatting within a formula 5

Back
Top