Formatting Text and Numbers

Formatting text and numbers in Excel makes it more presentable and readable to whoever use your¬†worksheet, like on the currency, it’s way better to have a currency symbol before the number to determine the exact value not just a number.

In this lesson you will learn how to add the currency symbol and decimal to any number and also change the font style of the text.

Add Currency Symbol and Decimal

To add the currency symbol in any number entered in a cell, select the cell/cells that you want to format, then on the Home tab, “Numbers” group, select “Currency” on the drop down.

Add Currency Symbol - Editing Data

To customize the currency symbol, click “More Number Formats…” at the bottom of the dropdown, on the popup Format Cells Window, on the “Number” tab “Currency” category, select the Symbol that you want on the Symbol field, then click “OK” to apply.

Adding Custom Currency symbol

Change Font Style

To change the Font Style of Cell entries, while the cell that you want to change is selected, In the Home Tab, Font group, select the font style that you want in the dropdown. See the screenshot.

Change font style - Editing Data

Something to clarify? Write it below

This site uses Akismet to reduce spam. Learn how your comment data is processed.