Formula Method The most obvious way to increment a number in Excel is to add a value to it. Start with any value in cell A1, and enter "=A1+1" in cell A2 to increment the starting value by one.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you four easy ways to convert numbers stored as text to real numbers.

How to use Excel's new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

Want an easier way to share your spreadsheet or workbook with non-Apple users? We’ll show you how to convert Apple Numbers to Excel on Mac, iPhone, and iPad.