| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".00 Ro
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".0
"Rick Rothstein (MVP - VB)" wrote: 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 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show a "$" at the beging of this result =ROUND(D99*0.75,4)&".0
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. Does this do what you want? ="$"&ROUND(D9*0.75,2)&".00 Rough" Rick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Linear Mode
