You can always check Google first. A perfectly good answer came up in my
search:
http://www.thepolivkagroup.com/include/calc.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"jculjk" 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:

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:

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:

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:
|
|

"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:
|
|