Convert numbers to text format in Excel

By default, Excel shows number format to a right corner of a cell and text format to left. Follow these steps to convert numbers to a text format:

Method 1

1. Select range of cells.

2. To open Format Cell box, press Ctrl + 1, then select Text from Category list and press OK.

3. Result.

Method 2

After selecting the range, go to Home tab, in Number section click on drop down menu and select Text format.

Copyright © 2016 - 2018 | All Rights Reserved