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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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
 
Rick Rothstein (MVP - VB) said:
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.
Click to expand...
 
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
 
Back
Top