View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billy Liddel Billy Liddel is offline
external usenet poster
 
Posts: 527
Default Convert decimals to area measurement

Ajmul

Returns a text value =INT(A6*4)& " Roods" & " " &MOD(A6*4,4)& " Perches"

I have not tried it for fractions of an acre

Peter

"ajmull" wrote:

I am working on a history project in which I need to convert acreage given in
decimal form to acres, roods and perches (40 perches = 1 rood; 4 roods = 1
acre). Is is possible to do this in Excel?