| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 32818 | 2003-04-29 03:13:00 | Excel 2000 Problem | CYaBro (73) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 139768 | 2003-04-29 03:13:00 | I have in front of me a Toshiba latop running Win98SE and Office 2000. The problem is with an Excel spreedsheet. I'm trying to enter in a whole number i.e. 1 or 2 or 30 or 560 etc but when entered it automatically makes the number 0.01 or 0.02 or 0.3 or 5.6 etc. but on the screen it doesn't show the decimal places. But that's not an issue because I don't need to see the decimal places, but want to have the numbers show as I have entered them. Any ideas? Cheers |
CYaBro (73) | ||
| 139769 | 2003-04-29 05:27:00 | Left click on a cell - right click - formatt cells - click on number. You have choices of $ fractions etc. Bye |
Peter H (220) | ||
| 139770 | 2003-04-29 21:39:00 | Thanks for the reply but I already tried that. Had a brain wave overnight and remembered an option in the Tools - Options - Edit tab. In there is an option to enable set decimal places. I disabled this and it fixed it. :) |
CYaBro (73) | ||
| 1 | |||||