View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Convert decimals to area measurement

G'day Ajmull

Try this:

Formula View:
Columns

A B C
Row 1 Acres Roods Perchs
Row 2 Your input =A2*4 =B2*40

Actual View:

Columns

A B C
Row 1 Acres Roods Perchs
Row 2 1 4 160


HTH
Mark.