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

Giganews Newsgroups
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.

Replies