|
Visual Basic (VB and VBA) |
|
Copyright 1999-2001 Christopher Greaves. All rights reserved. Home Page and email to [email protected] |
| If in doubt, record a macro and inspect the entrails! |
Please read the DISCLAIMER.
Here is an INDEX to all the procedures.
You will probably need one copy of my GLOBAL DECLARATIONS.
Public Function strFmt3dec(lngInd) As String ' Procedure : strFmt3dec ' Description: Format a number to comma-separator, 3 decimal places. ' By: Chris Greaves Inc. ' Inputs: Numeric. ' Returns: STRING ' Assumes: None. ' Side Effects: The document selection point will be reloaded. ' Tested: By the calls shown below. strFmt3dec = Format(lngInd, "###,###,##0.000") 'Sub TESTstrFmt3dec() 'MsgBox strFmt3dec(0) 'MsgBox strFmt3dec(123) 'MsgBox strFmt3dec(123456) 'MsgBox strFmt3dec(123456789) 'MsgBox strFmt3dec(-0) 'MsgBox strFmt3dec(-123) 'MsgBox strFmt3dec(-123456) 'MsgBox strFmt3dec(-123456789) 'End Sub End Function
| We all knew nothing when we started … |
|
Home Page and Contact Information Send email to [email protected]. This page was last updated Thursday, November 15, 2001 |