Excel displays the original number up to 11 digits. When you enter a number that has more than 11 digits, Excel does not display the original value. Instead, it displays the number in the exponential ...

Whether you are generating lottery numbers or sample data for a survey, random numbers are easy to create in Excel. While ...

When you apply Microsoft Excel's percentage number format to a cell already containing a number, it multiplies the value by 100. This can be frustrating, as there's apparently no easy way to stop this ...

Some of my reports list Social Security numbers. Since the reports are often viewed by others, I need a convenient but secure way to hide those numbers—such as making only the last four digits visible ...

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...

Spreadsheet programs are effective tools for successful businesses. These programs can significantly reduce the time needed to create reports and financial statements used to manage a business. Most ...

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...