Learn how to automatically insert decimal points in Excel spreadsheets using Excel Options, Registry Editor orl Group Policy Editor.

Q. Thanks for your advice in the September 2001 issue on converting fractions in Excel into decimal values. But how about those of us who need to do the reverse—that is, convert decimal values into ...

By placing a zero before the decimal, the number is more readily recognized as less than one. By configuring a custom number format you can tell Excel to remove leading zeros.

How to convert time values into decimal values in Excel Internally, Excel stores the time as a decimal value. The quickest way to see that time value is to change the format.