View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandra Chong Sandra Chong is offline
external usenet poster
 
Posts: 1
Default formatting decimal points

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.