Results 1 to 17 of 17

Thread: [RESOLVED] Problem formatting an array

Threaded View

  1. Nov 19th, 2008, 08:47 AM #1
    MrDudemeister
    MrDudemeister is offline

    Thread Starter
    Junior Member
    Join Date
    Oct 2008
    Posts
    24

    Resolved [RESOLVED] Problem formatting an array

    I need to format every number in MyArray with a thousand separator. I want it to add ",".

    Since the numbers in the array will be <= maximum value of a Long, which is 2,147,483,647.

    What should the "???????" be replaced with? .
    Code:
    For i = LBound(MyArray) To UBound(MyArray)
Myarray(i) = Format(Myarray(i), ???????)
Next
    Last edited by MrDudemeister; Nov 19th, 2008 at 08:53 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width