Common terms in Excel [Format Cells PART 2]

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

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
text-to-numbers-example.png (2.54 KiB) Viewed 571 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 571 times

2. Numbers preceded by an apostrophe are also treated as text. Select cell A5 and manually remove the apostrophe.
remove-apostrophe.png
remove-apostrophe.png (2.9 KiB) Viewed 571 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
copy-empty-cell.png (27.23 KiB) Viewed 571 times

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

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

3d. Click OK.

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

4a. You can also use the VALUE function.
value-function.png
value-function.png (3.2 KiB) Viewed 571 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
right-function.png (2.6 KiB) Viewed 571 times
_____________________
Thanks & Regards
Saran BL

www.i-metrik.com

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