Thread: How to display the value in different format?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default How to display the value in different format?
Hello Eric,

=--TEXT(B1,"0."&REPT("0",INT(LOG(B1))-1+MAX(1,1+LOG(A1)))&"E+0")

If you like to explore how I came up with this:
http://www.sulprobil.com/html/nsig.html

Regards,
Bernd
Reply With QuoteReply With Quote