Excel: Simple and Effective Strategies to Learn and Execute Excel Programming by Daniel Jones

Author:Daniel Jones [Jones, Daniel]
Language: eng
Format: azw3
Published: 2018-02-22T16:00:00+00:00

Example 1: the first column in your spreadsheet contains a text representation of numbers. The value function will be used in the second column so the text values can be converted.

A1: one hundred and eleven

B1 =VALUE (A1) – 111

Example 2: you can use the value function with the left function to extract numeric values from a string of text.

A1: 28 days this month

B1: =VALUE (LEFT (A1, 2)) – 28

Convert number to text

Converting a number to text with an apostrophe

One of the quickest ways to convert a number into text is to place an apostrophe in front of the number. You will not see the apostrophe in the cell, but Excel will be informed to treat the contents of the cell as text. You will also find this useful when you must force Excel to display zeros on numbers such as a phone number.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.