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.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbNum2Str

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.

20101115_PB_01_sbNum2Str_Screen
20101115_PB_01_sbNum2Str_Code
20101115_PB_02_sbNum2Str_Code

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   Contact   Disclaimer   Download