Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Whole number converts to decimal
Somehow, I've changed a setting in Excel so that when I enter a number (say,
5) into any cell on a blank worksheet (thus, the cell is formatted as general) and hit enter, the number is automatically converted to .05. The only way I can stop Excel from doing this is by entering a "." after the number, so it realizes that I want the whole number. It only does it when the cell is formatted as General or Number (even when the decimal places is set to 0 -- putting in 4 will return .04 which displays as a 0). Any ideas? |
#2
|
|||
|
|||
Nevermind, I figured it out from another post. I had the "Fixed Decimal"
checked and set to 2 under options. Not sure how, but that's what it was. "dmbRedGetta" wrote: Somehow, I've changed a setting in Excel so that when I enter a number (say, 5) into any cell on a blank worksheet (thus, the cell is formatted as general) and hit enter, the number is automatically converted to .05. The only way I can stop Excel from doing this is by entering a "." after the number, so it realizes that I want the whole number. It only does it when the cell is formatted as General or Number (even when the decimal places is set to 0 -- putting in 4 will return .04 which displays as a 0). Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting number string to number with decimal | Excel Worksheet Functions | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
How do I change a text fraction. eg 1 1/2 into a decimal number, . | Excel Worksheet Functions | |||
How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) |