Asked By
E.Robe
10 points
N/A
Posted on - 02/13/2012
Hi All,
How can i add a $ symbol in excel cell
I am trying to add a $ in a cell but it just disappears.
Thanks
How can i add a $ symbol in excel cell
Hello E.Robe.
I just read your question about inserting $ symbol into excel cell. Robe, it’s very simple to insert symbol into spreadsheets, please follow these steps to insert your desired symbol into any cell in excel spreadsheet.
First of all, select your desired cell, where you want to insert symbol.
Now, click on insert tab in Excel.
You will see symbol button in this tab, click there.
Upon clicking on symbol button, symbol directory will be opened, now find your desired symbol and finally click on insert. Your desired symbol will be inserted into cell.
I hope with this your issue is resolved.
Answered By
rayem
0 points
N/A
#86325
How can i add a $ symbol in excel cell
1) you just press right click on specified cell
2) press [format cell], Â
3) number, currency button
4) symbol $ Â and also select you desire nagative number.
must be check symbol $ sign
Â
Â
Â
Answered By
serveen
0 points
N/A
#86326
How can i add a $ symbol in excel cell
Hi Robe,
Â
  I went through your query and come up with this solution as shown below. Please have a look into it
Â
1. Maybe the cell's formatting is off, have you tried resetting the cell formats and make sure there are no custom formats in the way.
Â
2.Right click on the cell(if want to have a change on compelte column, Select complete column) and select the format cells… option as shown below.
Â
Â
3.Select the tab "Number" and category as "currency":Â
Â
  3.1 Choose the '$'sign on right hand side Symbol.
Â
  3.2 Also make sure that you select tne Negative numbers: as ($1,234.10) and check with sample how it shows the number with  '$'sign or not.
 Â
Â
Hope this might have resolve your query.
Â
Regards,
Serveen Software Systems
Â
Answered By
Danjie7
0 points
N/A
#86328
How can i add a $ symbol in excel cell
Hi E. Rode,
I have read your posting about your question regarding on how to put a dollar sign ($) to excel cell. I'll be more than glad to help you work this out. What I can do for you right now is to forward to you a couple of instructions and it will also serves your guideline. Here I attached a coherent sample on how to put a dollar sign on excel cell.Â
 
Â
-
Select the Insert tab at the menu bar then look for Symbol. The Symbol  tab is right next to Object tab . You’ll see a pop-up message once you point your mouse pointer to the Symbol tab and the tab will automatically highlighted in yellow. When you see it, click Symbol.
2. After clicking the Symbol tab, the second screenshoot above will be the output. The dollar sign appears at the fifth column of the first row. Then click Insert button below then click the Close button.
3. This will be the result.
I hope this guide will help you thoroughly.Â
Have a great day!
How can i add a $ symbol in excel cell
Hi, welcome you in techyv.com. Here you can find out more information what you need everyday.
Here is your questions answare..
 1. open Excel
 2.Then visit 'HOME'
 3. Here you see $ symbol.
 4. Click beside the $ symbol
 5.select the box where you want to give $ symbol
 5. select $ symbol
 6. write some number it should be see like $ 7…
 hope it will be work… thank you.
Â
Â
How can i add a $ symbol in excel cell
You can put whole functions into the DOLLAR function, like this:
=DOLLAR(SUM(A1:A4), 2)
You can also use cell formatting on the cell in question (Format – Cells, the Number tab, choose Currency).
🙂
