Thread: Rounding/Significant figures
View Single Post
  #2   Report Post  
Bernd Plumhoff
 
Posts: n/a
Default
Hello,

Suggestion:
=TEXT(ROUND(A1,-3),"0.0#E+0")

HTH,
Bernd
Reply With QuoteReply With Quote