Excel 2003 Got Corrupted and would like to send a copy to MS.URGEN
While running some Macros for financial mathematics, which involved some
random number generation, the following shocking development happened across all spreadsheets present on the machine. Typing 3 results in .000003 Typing 4 results in .000004. What a shock? Can I send a copy to some address, please with regards -- beetal ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/communities...el.programming |
Excel 2003 Got Corrupted and would like to send a copy to MS.URGEN
Before you send it to MS, try:
Tools|Options|Edit tab|uncheck fixed decimal places. It sounds like someone was working with very small numbers and turned this setting on so they wouldn't have to type the decimal places and 0's. Useful for him/her. Not so nice to leave it that way for you. BEETAL wrote: While running some Macros for financial mathematics, which involved some random number generation, the following shocking development happened across all spreadsheets present on the machine. Typing 3 results in .000003 Typing 4 results in .000004. What a shock? Can I send a copy to some address, please with regards -- beetal ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/communities...el.programming -- Dave Peterson |
All times are GMT +1. The time now is 10:59 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com