Have you ever opened your spreadsheet only to find your carefully typed numbers missing their decimals, or worse, transformed into something like 2.95E+07? If yes, you’ve seen the downside of relying ...

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. If ...

on a worksheet, but the same values may look awkward in an Excel chart. By default, charts use the same number format as the worksheet’s original data series. The good news is you do not have to ...

If you are unaware of Microsoft Excel's "Format Cells" option, then you will discover it offers a wealth of formatting possibilities. Aside from the many built-in number formats, Excel allows you to ...

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. Boldface type ...

You've all seen it, how different web sites and email signatures format their phone numbers. Some do 212-555-5555, some do (212) 555-5555, some do 212.555.5555, some do 212 555 5555, some do ...

Numbering a list is an easy task in Word. But changing how those numbers look is a bit more complicated. Learn how to create your own custom number format. In Word, you can quickly number a list by ...