how do I convert sq. meters to hectares in a batch

G

Glenn

1bigfokker wrote: Nothing!



Please put your questions in the Body, not the Subject.



1 Hectare = 10,000 Square Meters

Put 10,000 in a cell, select and copy that cell. Select the cells with Square
Meters, Edit / Paste Special / Values / Divide.
 
D

David Biddulph

Divide by 10000, either in a formula or by Paste Special/ Divide.

[And next time, please remember to ask your question in the body of the
message, not just in the subject line.]
 

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

Help Please 6
New computer, how do i move outlook 365 ENTIRELY? 0
How do i convert kg to tonnes in excel? 1
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
Automatic Value conversion 3
how do I unmerge an excel document? 2
how do I change number format from 3,999.89 to 399989 0
"go to" "blanks" after using a formula 2

Top