View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default significant digits

How are your significant digits defined? I would just translate that
into decimals, the example you gave is 1 decimal place. So you can use
ROUND for a formula or format cells to "0.0".