Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel INDIRECT Function
  • How to reference named range different sheet in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Last row number in range
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • How to Create Column Chart in Excel
  • How to add Trendline to a chart in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • Understanding Anova in Excel
  • How to create dynamic reference table name in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation must not contain
  • Excel Data validation must begin with
  • Excel Data validation date in specific year
  • Excel Data validation unique values only

Tag: Custom Number Format

Convert Text to Numbers in Excel

by

By default, text is left-aligned and numbers are right-aligned in Excel. Atimes user enter inverted comma before inputting data values in a cell which automatically converts a number to text. This example teaches you how to convert ‘text strings that represent numbers’ to numbers. 1. Select the range A1:A4 and change the number format to General. 2. Numbers preceded by …

Continue Reading

Currency vs Accounting Format in Excel

by

The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference. 1. Enter the following values. 2. The Currency format places the dollar sign right next to the number. 3. The Accounting format aligns the dollar signs at the left edge of the cell and displays a dash for zero values. Note: …

Continue Reading

Change Fractions Format in Excel

by

Excel always reduces fractions to its smallest denominator. This example teaches you how to enter a fraction in Excel and how change the format of a fraction. 1. To enter the mixed fraction 1 4/7 (one and four sevenths), type 1 4/7. To enter the fraction 4/7 (four sevenths) into cell A1, select cell A1 and type …

Continue Reading

Convert Numbers to Text in Excel

by

By default, numbers are right-aligned and text is left-aligned in Excel. This example teaches you how to convert numbers to ‘text strings that represent numbers’. 1. Select the range A1:A4 and change the number format  to Text. 2. Precede a number by an apostrophe and it will also be treated as text. 3a. If you add text to a number and …

Continue Reading

Number Decimal Places in Excel

by

Learn how to show fewer decimal places in Excel without changing the number itself. You can also round a number. 1. Enter the value 2.175 into cell A1. 2. On the Home tab, in the Number group, click the Decrease Decimal button twice. Result: Note: if you look at the formula bar, you can see that cell A1 still contains the …

Continue Reading

Advanced Number Formats in Excel

by

Excel has many built-in formats. You can select standard number formats such as General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text on the home tab of the ribbon using the Number Format menu. If you cannot find the right format, you can create a custom number format. N/B: A custom number …

Continue Reading

Excel Custom Number Format with Leading Zeros, Add Text, Colors Example

by

Beyond the built-in options: custom formatting The Format Cells dialog offers so many options available “out-of-the-box.” The available format category and type options go far beyond the basics. But, if what is available still doesn’t meet your requirements, you can always create a custom format. Let’s consider a set of numbers. We start by opening the Format …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to compare two text strings in Excel
  • How to convert text string to array in Excel
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • How to extract substring in Excel
  • Remove text by variable position in a cell in Excel
  • Get day from date in Excel
  • Convert decimal minutes to Excel time
  • Roll back weekday to Friday base on a particular date in Excel
  • Basic timesheet formula with breaks in Excel
  • Find Last Day of the Month in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
  • YIELD function: Description, Usage, Syntax, Examples and Explanation
  • XIRR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate original loan amount in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles