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

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