Wednesday, July 25, 2012

How to Enter 17 Digits Into Microsoft Excel 2003


1. Enter your 17-digit number in a cell in an open spreadsheet. If the number displays in scientific notation, you have to adjust the cell format to have it display all 17 digits.
2. Click on the 'Format' pull-down menu at the top of the spread sheet, and select 'Cells' to format how numbers will appear within an individual cell.
3. In the 'Format Cells' box that appears, select 'Numbers' from the tabs. You'll be presented with a series of choices for formatting numbers, such as currency, dates or percentage. Select 'Numbers' from the list. This will change the appearance of numbers in cells, removing scientific notation and displaying all digits as originally entered.
4. You may also want to check the box labelled, 'Use 1000 separator (,)', so that your 17-digit number is displayed with commas, as this makes the numbers much easier to read.

Blogger news