Customise Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorised as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyse the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customised advertisements based on the pages you visited previously and to analyse the effectiveness of the ad campaigns.

No cookies to display.

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.

1. Formatting Numbers

You can use the “Number” group in the Home tab to format numbers.

a. Basic Number Formats

  • General: Default; displays numbers as they are entered.
  • Number: Includes commas as thousand separators and allows setting decimal places.
  • Currency: Formats numbers as monetary values with currency symbols (e.g., ₱1,000.00).
  • Accounting: Similar to Currency, but aligns the currency symbols and decimal points.
  • Percentage: Multiplies the number by 100 and adds a % sign.
  • Date/Time: Formats numbers as dates or times (e.g., 18/11/2024 or 3:30 PM).
  • Fraction: Displays numbers as fractions (e.g., 1/2).
  • Scientific: Uses scientific notation (e.g., 3.2E+02 for 320).

b. Custom Number Formats

Go to Home > Number Group > More Number Formats > Custom to create your format.
Examples:

  • #,##0.00 – Adds commas and displays two decimal places.
  • 00000 – Ensures numbers have 5 digits (e.g., 123 becomes 00123).
  • [$₱]#,##0.00 – Adds the ₱ symbol for Philippine pesos.

2. Formatting Text

Text formatting can enhance the presentation of data.

a. Text Alignment

  • Wrap Text: Keeps text within a cell by wrapping it to the next line.
    (Home > Alignment > Wrap Text)
  • Merge & Center: Combines cells and centers the text.
    (Home > Alignment > Merge & Center)
  • Indent: Adds space between the text and cell edge.

b. Font Styling

  • Bold, Italic, Underline: Use buttons in the Home tab.
  • Font Size and Type: Choose from the Font Group.
  • Color: Change the text or background color.

c. Conditional Formatting

Highlights text or cells based on conditions.

  1. Select the range.
  2. Go to Home > Conditional Formatting.
  3. Choose a rule (e.g., “Highlight cells greater than 1000”).
  4. Apply formatting styles.

3. Formatting Cells (Text and Numbers Together)

  • Borders: Add cell borders for clarity. (Home > Font > Borders)
  • Shading: Add background color. (Home > Fill Color)
  • Column Width/Row Height: Adjust for proper display. (Home > Format > Column Width/Row Height)

4. Shortcut Tips

  • Ctrl + 1: Opens the Format Cells dialog box for advanced options.
  • Ctrl + Shift + %: Applies percentage format.
  • Ctrl + Shift + $: Applies currency format.
  • Alt + Enter: Inserts a line break within a cell.

Let me know if you’d like examples or assistance with specific Excel tasks!

Something to clarify? Write it below