+ Reply to Thread
Results 1 to 3 of 3

thousands comma separator in VBA

  1. #1
    Wendy Francis
    Guest

    thousands comma separator in VBA

    Hi
    I have variables defined in an Excel macro as Long, and I want them to
    return the value in a Word Report with thousand comma separators - is there
    a way of doing this please?
    Wendy Francis
    [email protected]



  2. #2
    Registered User
    Join Date
    01-18-2005
    Location
    Australia
    Posts
    29
    Hi Wendy

    You can use FormatNumber() to format your variable before you produce your report.

    eg. YourVariable = FormatNumber(YourNum, , , , vbTrue)

    Regards
    Shaun

  3. #3
    Wendy Francis
    Guest

    Re: thousands comma separator in VBA

    That's brilliant Shaun. Thanks very much.

    Wendy



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1