View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KHess KHess is offline
external usenet poster
 
Posts: 1
Default Automatic rounding and placement of decimals.

All of a sudden, or so it seems, Excel has decided that any whole number I
type in needs two decimal places. 328 becomes 3.28 When I go into
formatting to change the number of decimal places, it then decides to round
up and 328 becomes 3. The only way I can get it to actually put 328 in the
cell is to type '328. Then I get an error message that asks if I want to
convert the text to a number. What is going on and what can I do to fix it?

Help!