I found out, after posting a similar complaint... that to have decimal
placement similar to a calculator... go to TOOLS, then OPTIONS, then EDIT,
then check FIXED DECIMAL PLACEMENT (select 2)... It works!!!! Sorry for my
former complaint.

Ken / San Diego

"Skip_Cycle" wrote:

I absolutely totally agree. This is BS. Most accountants are used to the way
a calculator performs in accounting mode. Excel should work in the same
manner like it did in previous versions. HELLLLLOOO!!!!!!! The idiot who made
this change needs to be fired to help begin the purge of all those people
that keep making Microsoft applications user unfriendly.

"sconnyite" wrote:



"Jackson" wrote:

I am using Excel 2003. I have set my options to a fixed decimal with 2
places. When I enter 1495 the cell shows 14.95 but when I type in 14. the
cell shows .14. How do I get 14.00 without entering the zeros?


Did anyone actually figure out how to make this work as it did with previous
versions of Excel? This bites. The fact that you can trick it by typing
"14.0" vs. "14." is way beside the point. The point is how is this logical:
14. = .14? It is not. Wake up here Microsoft. You changed something that
was working well. Please stop doing that.