Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel formulas...How do I include a dollar sign ($) when entering a formula?
I am trying to calculate different items from different worksheets. But I want to put a dollar sign in the formula. How do I accomplish that?
Road...thanks, I totally forgot about that. It's been a while...
And thank you too j
2 Answers
- jmorgeLv 61 decade agoFavorite Answer
not real sure of exactly what you're trying to accomplish. If you could include an example it would help.
assuming you're just trying to use a $ sign as a character in some formula, you'll have to put double-quotes "$" around it.
for example:
="$"&A1 (where A1=50)
result would be $50
- Anonymous1 decade ago
The dollar sign has no function in a formula. However, the result displayed can have a dollar sign. Just right click the cell and do format, cell, number, and pick currency, and how many decimal places you want.
