VB Formatting Question for Excel Application

[Annie Bender]

Hi again everyone. Is there a standard formatting function available in VB to insert the 1000 comma separator in a calculated numeric result? In Excel, the same can be achieved using the standard function =TEXT(123456,"0 00\,000") to produce 123,456. If not, what would you suggest as coding for a customized function or sub? The formatted result does not get used in further calculations. Thanks as always for helping out a newbie.

Annie in Florida

[vb5prgrmr]

There is the Format Function and the FormatNumber Function In VB6.0...



Good Luck

[Annie Bender]

Thank you. I'm embarassed. I usually do a search before resorting to posting a question, but I obviously missed it this time or I would have found the FORMAT function easily. It works nicely. Thanks vb5prgrmr.

Annie