Friday, January 28, 2011

How to Disable Excel 2003 From Automatically Changing Cells to Scientific


1. Click the Windows 'Start' button. Type 'excel' in the search text box and press 'Enter.' This is the shortcut command to open the Excel software. When Excel opens, it automatically loads a default, new spreadsheet. You can use this default spreadsheet to create your book.xlt file.
2. Click the 'Format' menu item. From the menu, click 'Style.' This opens a 'Style' window where you edit the format of your cells. Check the 'Number' format.
3. Select the number format you want to use in the drop-down box. You can also customize the number format by clicking 'Modify.' Most necessary number formats are sufficient for creating a stylized spreadsheet.
4. Click 'OK' to save your changes. Click the 'File' menu item, then click 'Save As.' Select 'xlt' in the file format drop-down box. Type 'book.xlt' as the file name and click 'Save.' Click 'Yes' to confirm that you want to overwrite the existing template file.

Blogger news