Email from excel: Format dollar amount in outlook body

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

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
 
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.
 
Hi Sam

You can use the Format function for the cell with the amount
when you create the body
 
Correct the format function:


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

Code is for illustration only.
 
Back
Top