One way is to put it in a variable as a sting using Format:

myStr = Format$(1234567, "1,234.567")
Text = "Now my number reads " & myStr & " as a string."

Code is for illustration only.

"sam" wrote in message
...
Hi All,

I know how to email from excel. But I want to know how can I display
dollar
amount in specific format.

For eg: rite now dollar amount is displayed like 1234567 and I want it to
be
1,234,567

How can I do this?

Thanks in advance