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

=--TEXT(A1,"0.0E+0")

Note that 0.99 presented with 2 significant digits still is 0.99.
Leading zeros dont count.

Regards,
Bernd
Reply With QuoteReply With Quote