ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 Got Corrupted and would like to send a copy to MS.URGEN (https://www.excelbanter.com/excel-programming/421535-excel-2003-got-corrupted-would-like-send-copy-ms-urgen.html)

BEETAL

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

Dave Peterson

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