| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I convert sq. meters to hectares in a batch
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I convert sq. meters to hectares in a batch
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I convert sq. meters to hectares in a batch
It depends on what the batch looks like.
1 ha = 10,000 sq m Regards Fred "1bigfokker" wrote in message ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I convert sq. meters to hectares in a batch
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.] -- David Biddulph "1bigfokker" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert meters to feet/inches | Excel Worksheet Functions | |||
| Dividing meters by hours = meters per hour | Excel Discussion (Misc queries) | |||
| Batch Convert CSV to XLS | Excel Discussion (Misc queries) | |||
| How do I convert Meters to Feet and Inches? | Excel Worksheet Functions | |||
| convert 1.2 miles to meters | Excel Discussion (Misc queries) | |||
Linear Mode
