How to convert numbers to text in excel
Feb 04, 2020
If you use Excel spreadsheets to store long and not so long numbers, one day you may need to convert them to text.
How to convert text strings that represent numbers to numbers
Feb 04, 2020
How to Convert Text to Numbers in Excel - learn how to correct this very common Excel issue with 5 different methods.
The Currency and Accounting format in Excel
Feb 03, 2020
The Currency format and the Accounting format in Excel are very similar to each other. This example shows the difference.
How To Enter A Fraction And Change The Format Of A Fraction In Excel
Feb 03, 2020
This example teaches you how to enter a fraction in Excel and how change the format of a fraction.
Dates and times displayed in a variety of ways in Excel
Feb 03, 2020
Even though dates and time are actually stored as a regular number known as the date serial number.
How To Check The Spelling Of Text In Excel
Feb 03, 2020
Learn how to use the inbuilt Spell Check option in Excel.
How To Show Fewer Decimal Places in Excel
Feb 03, 2020
Excel lets you control the number of decimal places displayed when you have numbers that aren't whole.
How To Return Sheet Name In A Cell
Feb 03, 2020
Return the name of a sheet into a cell using an Excel formula. This video tutorial explores the use of the CELL, MID and FIND functions to display the worksheet name in a cell.
How To View Multiple Excel Worksheets
Feb 03, 2020
Learn how to setup Excel to view two sheets side-by-side in the same workbook using the New Window feature.
How To Use The Consolidate Data In Multiple Worksheets
Feb 03, 2020
Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet.