43,560 apologies - I should have checked that there was support for units of area before opening up
my big keyboard
The Convert function doesn't directly support units of area, but can be used for "square units to
square units" conversion. Eg to convert 100 square feet to square metres use the following formula:
=CONVERT(CONVERT(100,"ft","m"),"ft","m")
Rgds,
ScottO
| Oh really? What's the exact formula to convert from an acre to square feet?
|
| Alan Beban
|
| ScottO wrote:
| > Or you could use the Convert function in Excel -
| > =CONVERT(number,from_unit,to_unit)
| > Use the help key for syntax for the "from-unit" & "to_unit"
| > Rgds,
| > ScottO
| >
| > | If you can remember that a mile is 5280 ft and a square mile is 640
| > | acres, you can always derive it.
| > |
| > | Alan Beban
| > |
| > | jculjk wrote:
| >
| >
