can I put units in MS excel like 200 mm in formulae ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a MS excel sheet that involves lots of calculation ... my
units are mm and m , I have lots of formulae that need to be put with these
units ... can you please help me
 
You can display "mm" or "m" by formatting the cells that need it with a
custom format. Use something like

0 "mm" in the format

I don't believe that EXCEL will know what the units are when you do your
calculations. You'll need to address that in the calculations directly.
 

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

How can I write mm square, with 2 show up on top of mm.? 5
Excel Subtracting multiple columns from another column 3
Scrabble Value calculation for Welsh words 0
Choose 2 of 6 optional units for grade - formula question 1
Urgent Need help 4
multiple IF Formula help, Please 4
Sumproduct using wildcard for month only 6
Time In-Time Out/No. of Units 10

Back
Top