Decimal Defaults

ekyles

Board Regular
Joined
Mar 7, 2008
Messages
50
Something affected my PC so now new worsheets default to tenths. For example, if I type "2" into a blank cell, it appears as "0" and its value is "0.2". In order to get "2", I have to type "2" and "0". Any help would be appreciated! Thank you in advance.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,939
What version are you using? Under Tools-->Options in 2003 and earlier there is an editing tab I believe? that has an option for automatically insert a decimal point, maybe that got turned on or changed somehow?

In 2007 it is under the Office Button, Excel Options and then under the Advanced section.
 

ekyles

Board Regular
Joined
Mar 7, 2008
Messages
50
Thank you ... one follow up but different question ... I have a personal workbook - where do I save it? Now I just open it with each open of Excel. Where do I save it so it is permanent?

Thank you!
 

schielrn

Well-known Member
Joined
Apr 4, 2007
Messages
6,939
I would recommend just recording a macro into your personal workbook and it will create it for you and then you can use the search function on your pc to find where it stored it and then move your code into there and delete the recorded macro.

Or you can put it in this path:

C:\Program Files\Microsoft Office\Office12\XLSTART

Change office12 to whatever version you are using:

Office12 = 2007
Office11 = 2003
Office10 = 2000

and so forth.

Hope that helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,634
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top