In Excel how do I get 2 zeros to show automatically after I enter.

[Guest]

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?

 

[Amedee Van Gasse]

Jackson shared this with us in microsoft.public.excel.misc:

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?

What if you enter 123: 1.23 or 12.30?

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way

How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html

 

[papou]

Hi Jackson
Reset the options to normal (ie: untick "Fixed decimal")
Instead see Format, Cell, Number and choose Number with 2 decimals.

HTH
Cordially
Pascal

 

[Debra Dalgleish]

If you're using Excel 2003, the Fixed Decimal override doesn't work as
expected. You can add a decimal and a zero at the end of the number, to
override the fixed decimals. For example, type 14.0 and it will be
entered as 14

 

[Bob Phillips]

Format as #,##0.00?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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