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