Thanks for your help Mitch & Michael
You are correct Mitch: "You are trying to get both imperial and metric areas showing on the spaces' labels, i.e. on your floor plan, and in a worksheet, right?"
However I work in the UK so I work in metres for area but my client is from pre-metric days so prefers to work in feet.
This is a screenshot of what I did to get the space label to show both measurements: https://dl.dropboxusercontent.com/u/17200339/spaces.jpg You can see the space labels in the background.
Mitch, I thought the same about the round function too but the VW's help doesn't mention anything about specifying the degree the number needs to round to:
"round(number)- Rounds the specified number to the nearest whole number - =round(D11)
(returns the value in cell D11 rounded to the nearest whole number)"
Michael, thanks for the pointer for the other thread. My metre dimensions are working fine to whole metres as I've set that in the document preferences. The problem I think is that my feet are done using a formula so VW doesn't recognise them as a dimension unit and therefore doesn't round them off.
I'd also like to roll this out across the whole office so don't really want to rely on a script which needs to be recalculated each time.