Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro

[Guest]

I can make a constan show on the end of this formula but im having trouble
with the "$" symbol at the beging to show. The cell if formated in currency.

 

[Rick Rothstein \(MVP - VB\)]

I can make a constan show on the end of this formula but im having trouble

with the "$" symbol at the beging to show. The cell if formated in
currency.

Your Subject line got truncated so all of what you typed in not showing (at
least in Windows Mail it's not) and your question is not entirely clear to
me. Can you repost your message putting everything **inside** the body part
of your message?

Rick

 

[Guest]

Your Subject line got truncated so all of what you typed in not showing (at
least in Windows Mail it's not) and your question is not entirely clear to
me. Can you repost your message putting everything **inside** the body part
of your message?

Rick

I have a formula result that I want it to show up as currency but with the added text at the end of the formula that does not work for me, so i wanted it to show the $ symbol as a constant at the beging of the formula result. This is the formula i am using, =ROUND(D99*0.75,2)&".00 Rough". Hopefully this is a little clear.

 

[Rick Rothstein \(MVP - VB\)]

I have a formula result that I want it to show up as currency
Does this do what you want?

="$"&ROUND(D9*0.75,2)&".00 Rough"

Rick