Format Documentation

[ericksoda]

Does anyone know where the documentation is for the format function? I remember seeing some back in VB3 or so, but can't find a complete page for it now (and I can't find my VB3 docs).

Thanks.

David

 

[johnwm]

Try MSDN:

http://msdn.microsoft.com/library/d...y/en-us/office97/html/output/F1/D6/S5B22A.asp

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Dashley]

' Returns current system time in the system-defined long time format.
MyStr = Format(Time, "Long Time&quot

' Returns current system date in the system-defined long date format.
MyStr = Format(Date, "Long Date&quot

MyStr = Format(MyTime, "h:m:s&quot ' Returns "17:4:23".
MyStr = Format(MyTime, "hh:mm:ss AMPM&quot ' Returns "05:04:23 PM".
MyStr = Format(MyDate, "dddd, mmm d yyyy&quot ' Returns "Wednesday,
' Jan 27 1993".
' If format is not supplied, a string is returned.
MyStr = Format(23) ' Returns "23".

' User-defined formats.
MyStr = Format(5459.4, "##,##0.00&quot ' Returns "5,459.40".
MyStr = Format(334.9, "###0.00&quot ' Returns "334.90".
MyStr = Format(5, "0.00%&quot ' Returns "500.00%".
MyStr = Format(&quot;HELLO&quot;, &quot;<&quot ' Returns &quot;hello&quot;.
MyStr = Format(&quot;This is it&quot;, &quot;>&quot ' Returns &quot;THIS IS IT&quot;.