answersLogoWhite

0


Best Answer

1. Right click the particular cell

2. choose "Format Cells"

3. On the "Number" tab under "Category" left click on "Currency"

4. Set how many decimal places to show (you probably want to leave this as "2"), the symbol for the currency (e.g. £ or $ etc...) and how you wish negative values to be displayed.

5. Finally, left click on "Ok".

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Which sequence of commands should you use to format a number in one particular cell as a currency to add a symbol to the cell?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is example of command?

FORMAT , FDISK and SCANDISK are the external commands == == FORMAT , FDISK and SCANDISK are the external commands == ==


It is acceptable for dates to have a currency format?

It is acceptable for dates to have a currency format


What is example of external command?

FORMAT , FDISK and SCANDISK are the external commands == == FORMAT , FDISK and SCANDISK are the external commands == ==


Is currency a possible text format found in the Property Sheet task pane?

Currency is a number format, not a text format.


How do you get Excel to atuomatically display a number as currency or percent?

You format the cells to currency and then when numbers are put into them, they will automatically display as currency. to format a selected range of cells in Excel, press the Ctrl-1 key combination. This will bring up a dialog box. Click on the Number tab, then choose "Currency". Choose from a large range of symbols for the particular currency you want. The click OK.


What keystrokes beginning with format will give a currency format to any previously selected range?

Ctrl+Shift+$ will format a number cell as currency.


Currency style button in found in which tool bar in Microsoft Excel?

There is no currency style button. You can navigate to the format currency style option like this:Ribbon = HOME | Item = Format | Menu = Format Cells | Tab = Number | Category = Currency


What is a currency cell in a spreadsheet?

Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.Any cell can be formatted to show numbers in a currency format. If it is formatted to currency, then a cell could be said to be a currency cell, although it is not a formal term used.


Is currency a number format?

Yes


How do you format a cell to have a dollar sign appear immediately to the left of the first digit with no spaces?

Format the cell(s) as currency and ensure the currency is set to dollarsThe currency format can do that. As there are many currencies in the world, in different countries where the dollar is not used, a computer can be set to use a different currency symbol and it can also be done directly in Excel. So setting the cell format to currency format doesn't always put a dollar sign before the numbers.


Commands to delete operating system?

Format drive C


How do you change the entry to currency in Microsoft Excel?

Right-click on the cell or range of cells you want to change and click on cell format. From the cell format window, select a number format of currency.