Correct the format function:


myStr = Format$(1234567, "#,###,##0")
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