How can we help you?
Currency
- About
- Interface overview
- Screen elements
- Command menu
- Main menu
- Toolbar
- Change the display mode
- Hide or display tool group titles
- Hide or display the content of tool groups
- Customize the composition of the Favorites group of tools
- Add a button
- Change a button to run a macro
- Move an element
- Delete an element
- Clear the Favorites group
- Hide or display the Favorites group
- Formula bar
- Quick actions pane
- Workspace
- Sheet tabs
- Sidebar
- Status bar
- Language
- Files
- New file
- Save as template
- New from template
- Open a file
- File in .xls format
- File in .xlsb format
- File in .xml format
- View-only file
- File is used by another application or user
- Convert a file
- Recent files
- Send a file
- Preview and print
- Save a file
- Autorecovery of documents
- Close a file
- Sheets
- Insert a sheet
- Rename a sheet
- Hide or unhide sheets
- Duplicate a sheet
- Change sheets order
- Select a sheet from the list
- Zoom a sheet
- Hide or display zero values
- Delete a sheet
- Cells, columns, and rows
- Expand the workspace
- Select cell ranges
- Select colums or rows
- Multiple selection
- Resize cells
- Resize a column or row
- Merge or unmerge cells
- Insert columns or rows
- Hide or unhide a column or row
- Freeze columns, rows, or area
- Group columns or rows
- Delete columns or rows
- Data
- Enter data
- Enter data in a cell
- Automatically adjust cell width
- Floating cell
- Autofill cells
- Text formatting of formulas and numbers
- Sort and filter
- Define sort and filter range
- Automatic detection of the sort and filter range
- Sort
- Filter
- Copy and paste filtered data
- Refresh the filter
- Finishing work with sorting and filtering range
- Data validation
- Add data validation
- Edit data validation
- Delete data validation
- Actions with cells containing data validation
- Enter a date
- Enter a value in a cell with a drop-down list
- Find and replace
- Delete data
- Remove duplicates
- Links
- Insert a link to a web page or email address
- Insert a link to a place in the document
- Insert a link to a file
- Quick link insertion
- Follow the link
- Copy a link
- Edit a link
- Delete a link
- Keyboard shortcuts for moving between window elements
- Notes
- Special characters
- Current date or time
- Spelling and grammar
- Number formats
- Define cell format
- Open number format settings window
- General
- Number
- Split the number into digit groups
- Change the number of decimal places
- Customize negative number display style
- Currency
- Select a currency code or symbol
- Change the number of decimal places
- Customize negative number display style
- Accounting
- Date, Time, and Date and time
- Percentage
- Fraction
- Scientific
- Text
- Formulas and functions
- Formulas and functions basics
- Order of operations in a formula
- Reference cells and cell ranges
- Recalculation of formulas
- Select formula recalculation mode
- Recalculation of formulas in automatic mode
- Recalculate formulas manually
- Recalculate formulas when saving a document
- Automatic calculation
- Enter functions
- Function wizard
- Replace a formula with its result
- Copy and insert formulas
- Names in formulas and functions
- Reference to data in another document
- Structured references
- Calculation operators
- Tables
- Create a table
- Open the table settings pane
- Customize the appearance
- Rename the table
- Automatic table expansion
- Add a calculated column
- Select the type of calculation in the total row
- Convert a table to a regular range
- Delete a table
- Pivot tables
- Create a pivot table
- Create a pivot table based on the data in the current file
- Create a pivot table based on data from an external source
- Open the pivot table settings pane
- Define the structure of the pivot table
- Add fields
- Change the field order in a section
- Rename a field
- Select value calculation functions
- Delete a pivot table field
- Customize the pivot table parameters
- Change the data source
- Select the pivot table layout
- Customize the display of grand totals
- Customize the display of subtotals
- Enable viewing of cell details
- Edit captions
- Manage external sources
- View the list of external sources
- View information about an external source
- Change information about an external source
- Add an external source
- Delete an external source
- Filter data in a pivot table
- Filter data using the report filter
- Filter rows and columns by values
- Filter rows and columns by condition
- Clear the filter
- Sort data in a pivot table
- Collapse or expand the elements of pivot table
- View cell details
- Refresh a pivot table
- Copy a pivot table
- Delete a pivot table
- Charts
- Insert a chart
- Open the chart settings pane
- Chart settings
- Open chart elements settings
- Customize the appearance of an element
- Customize element text formatting
- Adjust the parameters of axes and gridlines
- Hide or display an element
- Move a chart
- Copy, cut or insert a chart
- Change chart type
- Resize a chart
- Change data in chart
- Change the data range for the chart
- Delete a chart or a chart element
- Images
- Shapes
- Insert a shape
- Fill a shape
- Outline
- Select the color of the shape outline
- Select the thickness and line type of the shape outline
- Apply outline settings of the previous shape
- Delete shape outline
- Line style
- Select a line color
- Select the thickness and line type
- Apply the style of the previous line
- Reset the line style
- Resize a shape
- Fit shape size to text
- Change line length and angle
- Select arrowhead type
- Move a shape
- Delete a shape
- Format
- Font
- Font size
- Font formatting
- Font сolor
- Choose a color from the color sets provided
- Specify the color code manually
- Copy the color with an eyedropper
- Highlight color
- Alignment
- Rotate text
- Wrap text
- Character spacing
- Cell fill color
- Choose a color from the color sets provided
- Specify the color code manually
- Copy the color with an eyedropper
- Remove the fill color
- Cell borders
- Choose a color from the color sets provided
- Specify the color code manually
- Copy the color with an eyedropper
- Apply the last selected border style
- Delete borders
- Conditional formatting
- Copy and apply formatting
- Clear formatting
- Edit content
- Undo and redo
- Cut or copy data
- Paste the last cut or copied data
- Paste data while maintaining the original formatting
- Paste data without preserving the original formatting
- Paste data and transpose
- Clipboard history
- Automation tools
- Document protection
- Additional information
Application: Spreadsheet Home Edition
The Currency format is used to display numbers with a currency sign or code, which corresponds to the system settings of your computer.
A number formatted as Currency
To quickly convert a cell into the Currency format once the data is entered, perform the following actions:
1.Select a cell or a range the format of which you want to change.
2.On the Home tab, in the Number format group, click 
Currency.
A cell is automatically formatted as Currency if you specify the currency code next to the number. For example, 23.00 USD or USD 23.00. For the full list of supported currencies and their codes, see Appendix B.
If a cell is formatted as Text, entering the currency code will not affect the cell format.
The following parameters can be set for the number in the Currency format:
•Currency code and symbol to be entered next to the number
•The number of characters displayed after the dot (.) delimiter
•Negative number presentation type
Share:
Was this helpful?
Yes
No
Благодарим вас за обратную связь! Вы помогаете нам стать лучше.
Уточните, почему вам понравился материал:
Уточните, почему вам не понравился материал:
