Common terms in Excel [Format Cells PART 2]

User avatar
Site Admin
Posts: 9
Joined: 05 Apr 2020, 03:06
Location: PTP Nagar, Trivandrum

Common terms in Excel [Format Cells PART 2]

Postby Administrator 10 Apr 2020, 18:07

Text to Numbers
By default, text is left-aligned and numbers are right-aligned. This example teaches you how to convert 'text strings that represent numbers' to numbers.
text-to-numbers-example.png (2.54 KiB) Viewed 570 times

1. Select the range A1:A4 and change the number format to General.
general-format (3).png
general-format (3).png (2.87 KiB) Viewed 570 times

2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe.
remove-apostrophe.png (2.9 KiB) Viewed 570 times

3a. You can also combine step 1 and 2 by adding an empty cell to the range A1:A5. By doing this, you let Excel know that these text strings are numbers. Copy an empty cell.
copy-empty-cell.png (27.23 KiB) Viewed 570 times

3b. Select the range A1:A5, right click, and then click Paste Special.

3c. Click Add.
add-empty-cell.png (11.36 KiB) Viewed 570 times

3d. Click OK.

Result. All numbers are right-aligned and treated as numbers.
text-to-numbers-result.png (7.59 KiB) Viewed 570 times

4a. You can also use the VALUE function.
value-function.png (3.2 KiB) Viewed 570 times

4b. Here's another example. Use the RIGHT function (or any other text function) to extract characters from a text string and then use the VALUE function to convert these characters to a number.
right-function.png (2.6 KiB) Viewed 570 times
Thanks & Regards
Saran BL

Was This Topic Useful?

Last 10 Members Who Visited This Topic

Ellentat, sminu, User avatar Administrator

Return to “Basic Excel Training”

Who is online

Users browsing this forum: No registered users and 1 guest