When you type a seven-or-ten-digit phone number into an Excel cell that uses the phone number format, Excel will automatically change the way the number looks so that it appears as a phone number ...

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

If, on the other hand, you need a table of multiple transactions or currencies for multiple countries, you can use Excel to accomplish this task with the Excel Add-In called EUROTOOL.XLAM.

Excel spreadsheets permit you to stay organized while managing large amounts of data, which can be organized in a number of ways. One popular way to organize this data is by date. Excel has a default ...

However, if you paste a differently formatted date, Excel accepts the source formatting. To further complicate the situation, Excel changes the format of the target cell to that of the pasted value!

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.

How to Change the Currency on iWork Numbers. The Numbers application that comes with Apple's iWork productivity suite is the equivalent to Microsoft's Excel application. As such, the application ...