Make decimal work properly in fixed decimal entry in Excel 2003.


G

Guest

In previous versions of Excel, when you have Options: Edit: Fixed Decimal
set, if a number then a decimal is typed (ex: "12."), the number in the cell
comes to "12.00". in Excel 2003 when "12." is typed and Fixed Decimal is set
to "2" the cell value will be "0.12". The old way seems to be the better way
to me.

----------------
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/office/community/en-us/default.mspx?mid=561fa92a-d06a-4e55-8899-2598e3c44e9f&dg=microsoft.public.excel.crashesgpfs
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top