I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.
If you need a non-scientific number representation with all significant digits and all leading and trailing zeros you can use this function sbNum2Str.
A related function is NSig which returns a number with a specified number of significant digits.


If you are interested in downloading a 19 KB Excel 2010 sample file which was used to create the examples on this page go to my Download page, please.

[Sulprobil] [Get it done] [Organisation] [IT] [Controlling] [Human Resources] [Family] [Contact] [Download] [Disclaimer]