how msgbox "x is " & x and put commas in?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

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.
 
Back
Top