View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Automatic rounding and placement of decimals.

'Tools' 'Options...' 'Edit' Tab UN-select Fixed Decimal Point. 'OK'
Micky


"KHess" wrote:

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!