I don't need no stinkin' decimal

[lPinkFloyd]

I don’t know what I jacked up but I did a good job of it. My problem is that when I enter a number in a cell it wants to convert it to a decimal

value. Example when I enter 2 it comes out as .02 and so on. If I enter it as 2.0 it is ok. I messed with the number format and can’t get it to

correct. Further more when I select no decimals in the format, when I enter a number it displays as 0 when I enter it. This is true in General,

number, currency, or accounting. I did an office repair and installed the Office disk and all. Did a reboot as well. What on earth is going on here?

 

[Aladin Akyurek]

Activate Tools|Options.
Uncheck Fixed Decimal on the Edit tab.

 

[marstonk]

Hi there,

is this happening even in blank new workbooks or a particular file??

 

[marstonk]

Try this

Tools, options, edit, uncheck "fixed decimal"

 

[lPinkFloyd]

Thanks guys,
I thought I posted a reply to you but it must not have taken. I figured it out just after I posted, but you guys verified it for me. I don't know what I was doing selecting that to begin with. Could that have happened by some other action? I guess not.