View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default significant digits

Hello Harlan,

Right.

--TEXT(A1,"0.0E+0") calculates the 2 most significant digits, and the
rest was IMHO presentational guess work.

Regards,
Bernd