Sunday, November 17, 2013

How to Convert Dates Times Into Decimals in Excel 2003


1. Click the Windows 'Start' button and type 'excel' in the search text box. Press 'Enter' to open the Excel 2003 software on your desktop.
2. Click the cell you want to format. Click the 'Format' menu item at the top of the window. Click 'Cells' from the list of options. This menu option opens a format window where you set up your cells' display options.
3. Click the 'Number' tab. Click the 'Number' option in the list. In the right panel with the list of number format options, click the decimal format you want to use.
4. Click 'OK' to save your settings. Type a date in the cell and watch the value change to a decimal number. Press 'Ctrl S' to save your changes.

Blogger news