|
|
|
|
| Author |
|
|
Registered
Join Date: Jun 2000
Location: bottom left corner of the world
Posts: 22,770
|
Excel question.
Hi Guys, a really strange thing has happened with the formating, I guess, in Excel. When I type in a number such as 45 it appears as .45. If I want it to appear and behave normally as the number 45 I have to type in 45. (or 45.00). I can live with this but I'm afraid I going to make a big mistake with something. Any ideas?
|
||
10-27-2009, 06:14 PM
|
|
|
Licensed User
Join Date: Feb 2003
Location: ....down Highway 61
Posts: 6,506
|
right click, format cells. And, yes, you will probably make big mistakes in Excel no matter how you format. It happens to the best of us. Excel does evil things in your spreadsheets that you do not want. I wish you luck.
|
||
|
10-27-2009, 06:18 PM
|
|
|
The Unsettler
Join Date: Dec 2002
Location: Lantanna TX
Posts: 23,885
|
You want it formatted as a Number with no decimal places. Formatted as General will work also but may do strange things when used in equations.
__________________
"I want my two dollars" "Goodbye and thanks for the fish" "Proud Member and Supporter of the YWL" "Brandon Won" |
||
|
10-27-2009, 06:24 PM
|
|
|
Registered
Join Date: Jun 2000
Location: bottom left corner of the world
Posts: 22,770
|
Thanks, but if I go Format, Cells, Number, and set it to 0 decimal places the number 45 displays as 0.
Format, Cells, General displays it as .45 Last edited by Bill Douglas; 10-27-2009 at 06:44 PM.. |
||
|
10-27-2009, 06:41 PM
|
|
|
The Unsettler
Join Date: Dec 2002
Location: Lantanna TX
Posts: 23,885
|
Quote:
Go to Preferences, look for Edit, Uncheck or set to 0, "Display this number of decimal places" option.
__________________
"I want my two dollars" "Goodbye and thanks for the fish" "Proud Member and Supporter of the YWL" "Brandon Won" |
||
|
10-27-2009, 07:05 PM
|
|
|
Registered Abuser
Join Date: Jul 2007
Location: Southwest Montana
Posts: 2,738
|
up to Format
Cells Number Box says decimal places select 2 should be OK then
__________________
MT 930 1987 930 - Gone but not forgotten A man with priorities so far out of whack doesn't deserve such a fine automobile. I would rather wake up in the middle of nowhere than in any city on earth - Steve McQueen американский |
||
|
10-27-2009, 07:07 PM
|
|
|
|
Registered
Join Date: Jun 2000
Location: bottom left corner of the world
Posts: 22,770
|
Nope
 When I enter in the number 45 it is 0.45 on the spreadsheet. |
||
|
10-27-2009, 07:19 PM
|
|
|
The Unsettler
Join Date: Dec 2002
Location: Lantanna TX
Posts: 23,885
|
Quote:
It's an application wide setting, not entry based like the Format option. There is a general setting there. I was just able to replicate your problem. It will not change a current entry, only entries that occur after the preference is changed. In my version of excell it's "Display this number of decimal places".
__________________
"I want my two dollars" "Goodbye and thanks for the fish" "Proud Member and Supporter of the YWL" "Brandon Won" |
||
|
10-27-2009, 07:27 PM
|
|
|
Registered
Join Date: Jun 2000
Location: bottom left corner of the world
Posts: 22,770
|
Mine is an earlier version of Excel and doesn't have an option called application preferences. the strange thing is it used to work well for the fairly simple stuff I do on it.
I just opened an old spreadsheet and it works fine, it's just anything new I do  Update: even on the old, OK, Spreadsheet if I enter a new number if does the 45 to 0.45 thing but the previously entered data displays OK. Last edited by Bill Douglas; 10-27-2009 at 07:43 PM.. |
||
|
10-27-2009, 07:39 PM
|
|
|
Registered
Join Date: Jan 2002
Location: Denver, CO
Posts: 97
|
Go to Tools - Options - General tab and uncheck the Fixed Decimal places box.
__________________
Kevin '87 Targa |
||
|
10-27-2009, 08:18 PM
|
|
|
Registered
Join Date: Jun 2000
Location: bottom left corner of the world
Posts: 22,770
|
Kevin. You are my friend. Thanks, this was driving me balmy LOL.
|
||
|
10-27-2009, 08:28 PM
|
|
