How to Change Text Format in Excel Office 365? – Easy Ways!!
Tags: excelbasics, excel365tutorials, textformattinginexce
Published: 2020-12-14 12:19:29

---
title: How to Change Text Format in Excel Office 365? – Easy Ways!!
published: true
date: 2020-12-11 07:20:38 UTC
tags: ExcelBasics,Excel365Tutorials,TextFormattinginExce
canonical_url: https://geekexcel.com/how-to-perform-text-formatting-in-microsoft-excel-365/
---

Do you want to change the appearance of your worksheet? We have the best solution for you to make it simpler and easier. You can simply change the Format of the Text in your Excel worksheet will make it more outstanding than any other data stored in the workbook.

**Text Formatting** in Excel allows the user to **customize** the **appearance** of the **text** so that the user can make changes in the workbook to enhance the look and feel. Let’s see them below!!
## Text Formatting in Excel:

Just follow these simple steps to enhance the view of your worksheet.

**Step 1:** Open New Excel Workbook.

**Step 2:** Now, type any value in the cell. For example, we have taken a date value **“3/4/2015”** ( **3rd April 2015** , the default date format in Excel is **m/d/y** )

**Step 3:** Select the cell.

![Example for Format change](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_8-4.png)<figcaption id="caption-attachment-4513">Example of the Format change</figcaption>

**Step 4:** In the **Home Menu,** you can find several options. Click on the **Text format option** which appears on the right-top of your Excel sheet.

![Text Format Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_6-7.png)<figcaption id="caption-attachment-4512">Text Format Option</figcaption>

**Step 5:** Just Click on the **drop-down arrow** , you can find all the format in the drop-down list.

![Text Format Options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_9-1.png)<figcaption id="caption-attachment-4515">Text Format Options</figcaption>

**Step 6:** Select any of the formats for your text. The selected format will appear in your text. For example, we have selected the **Long Date Format** for the text.

![Date Format changed](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_10-1.png)<figcaption id="caption-attachment-4562">Date Format changed</figcaption>

### Alternative method:

**Step 1:** Select the cell.

**Step 2:** Right-Click on the cell and choose the  **Format Cell option** from the menu.

![Right-Click Format Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-24.png)<figcaption id="caption-attachment-4516">Right-Click Format Cell Option</figcaption>

**Step 3:** The **Format Cells Window** will open. In the Window, select the **Number Tab** , you can find the different category options.

![Right-Click Category Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_2-21.png)<figcaption id="caption-attachment-4517">Right-Click Category Option</figcaption>

**Step 4:** Click on any category that you want for the text. For example, we have selected the **Date Category. **

**Step 5:** Now you can find all the formats for that particular category. For example, you can find all the date formats in the Format cells window as we have selected Date Category.

![Right-Click Date Category Option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_4-18.png)<figcaption id="caption-attachment-4518">Right-Click Date Category Option</figcaption>

**Step 6:** Now, the selected format will appear in your text.

![Example format changed](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_10.png)<figcaption id="caption-attachment-4519">Example format changed</figcaption>

## Verdict:

We hope that this short tutorial on Change **Text format in Excel Office 365** will help you a lot. Please leave a reply in case of queries and share your feedback in the comment section. Thank you for visiting our website [**GeekExcel.**](https://geekexcel.com/)

## Related Articles:

- [**How to change the font size in Excel.**](https://geekexcel.com/how-to-change-font-size-in-microsoft-excel-365/)
- [**change the font color in Excel.**](https://geekexcel.com/how-to-change-font-color-in-microsoft-excel-365/)
- [**How to change the font style in Excel.**](https://geekexcel.com/how-to-change-font-style-in-microsoft-excel-365/)