"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.