"my big keyboard" LOL!!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"ScottO" wrote in message
...
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

"Alan Beban" wrote in message
...
| 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
|
| "Alan Beban" wrote in message
...
| | 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:
|
|