Email from excel: Format dollar amount in outlook body
 

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

Email from excel: Format dollar amount in outlook body
 

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

Email from excel: Format dollar amount in outlook body
 

Hi Sam

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"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

Email from excel: Format dollar amount in outlook body
 

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