View Single Post
  #3   Report Post  
Carlos Antenna
 
Posts: n/a
Default

Rather than setting fixed decimal places in Tools|Options, format the cells:
Format|Cells|Number|2 decimal places.

-- Carlos

"SUKYKITTY" wrote in message
...
I have set options to fixed decimal 2 places. But when I enter numbers, i
have to enter all zeros after decimal point. Entering the period does not
work. For example,
100.00 must be entered as 10000. If i enter 100. it inputs 1.00. Excel
is
not accepting a period as a decimal place. Does anyone know what needs to
be
set for this problem? Thanks