|Subject:||how msgbox "x is " & x and put commas in?|
|Posted by:||Ian Elliott (ia…@hotmail.com)|
|Date:||Thu, 9 Oct 2003|
Thanks in advance.
I have an Excel macro that opens Word and gets a number
out of a Word file. I want to make a dialog box that
confirms with the user that the number is right (like "The
number will be 1,222,333"). I have a msgbox "X is " & x,
but x in the Word file does not have commas, but I want to
put in commas for readability. So right now it is "X is
1222333". Is there any easy way to do this?
Thanks for all help.