formatting decimal points

S

Sandra Chong

I formatted all cells to have 2 decimal points by going
to tools, options, edit,checking fixed decimals-2places.
If I need one or two cells to have whole numbers, in
previous versions of excel all I had to type was the
number and decimal point and hit enter. The number will
then read 1123.00 adding in the zeros after the decimal
which is what I need. Now in excel 2003 when I do that
the number reads 11.23, not adding the zeros as a whole
#. How can I fix this without having to type the zeros
in. This has slowed me down alot.
 
J

Jim Rech

That does seem to be a change in Excel's behavior with version 2003 and it's
a real good question why this was done. In any case I don't see a fix so
you might just have to type ".0" instead of "."
 

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

Similar Threads

Excel does not accept text format! 0
How to retrieve number of visible digits after decimal point in VBA 8
Mail Merge - displaying a conditional number of decimals 5
Formatting currency with the cents but without the decimal point 2
Open file and set numbers of decimal points 5
Paragraph numbering in Word 1
How to format without decimal point unless significant digits? 3
text box in userforms and international number format 0

Top