Question about Computers & Internet

# Excel is adding a decimal point

I have a new copy of Excel 2007 (I use Vista). When I enter a number into a cell, e.g., "23", it becomes "2.3" unless I enter a decimal after it -- e.g., 2.3. How do I fix this?

Posted by on

• Anonymous Feb 12, 2008

I have the same problem. Its not a formatting problem. I can open a new sheet and it does it too. 100 becomes 1. I can make it work if I format the column as text, but I need it to recognize the values as numbers. When I reformat the text back to numbers, the decimal points reappear. Its not fun.

×

Ad

## 1 Answer

• Level 1:

An expert who has achieved level 1.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

Problem Solver:

An expert who has answered 5 questions.

• Contributor
• 17 Answers

Dear Friend,

Try right clicking the selected cell, then choose the "format cells" option. Under the tab labeled number, you can choose many different options for how you want your number displayed. The "General" option will cause it to be just plain numbering with no decimals. Let me know if this helps, if not I still have more ideas which may help.

Arthur B

Posted on Jan 15, 2008

Ad

## 1 Suggested Answer

• 2 Answers

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

2 Answers

### What is formula to find percentage of females in my workplace?

To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

1 Answer

### How to do excel defined name formulas in microsoft excel 2007

Excel formulas really haven't changed at all, so any information you find on newer version of Excel will most likely apply to 2007.
However, to answer your question, let's look at the following scenario:
If A1 and B1 both have numbers and you want the cell C1 to be the result of adding A1 and B1, select the cell C1 and type "=SUM(A1:B1)" (without the quotation marks)
You can also do this by just typing "=SUM(" in C1 and then click and hold your mouse button on A1 and select B1 as well. Then close the parenthesis and press Enter. Done!

Hope this helps.

May 17, 2014 | Computers & Internet

1 Answer

### How do I fix how my percentage shows on the excel spreadsheet?

On the home toolbar, there is a section titled "Number". That would be where you would change the format to whatever you want it to. Even Red..
So, all you have to do is enter in the number you want and Excel puts in the decimal point, or the dollar sign, or the percent sign for you. And you can even change the amount of decimal places you want it to go as well..

Highlight the cells/numbers you want to format, then go to the number section on the toolbar (edit), and select the format that you want.

May 15, 2014 | Microsoft Corporation Microsoft EXCEL 97...

1 Answer

### My Microsoft EXCEL 2007 program has folowing behaviour. When I type a number i.e. 4, then coms 0.04. I did not find how to rectify this. Can you help me? My laptop MITAC 8640 has the problem, but also my...

Do this easy instructions on how to change back your numbers on excel.
• Run/Open your Microsoft EXCEL 2007
• Click the Microsoft Office Button , and then click Excel Options
• Click on Advance
• In there you will see Editing Options
• Then uncheck the box "Automatically insert decimal points" Then thats it.
Hope this solves your problem. Good Day.

Jun 21, 2011 | Computers & Internet

1 Answer

### What is the default setting for the f cut 5/4 and the 4320 add 2 I don't know what to have these options set at thanks EW Seattle

The selector you are asking about is the "decimal selector". The result displayed/printed, will be in a format according to the position that you have selected as follows:
f = floating (the result will be in the number of decimal places that were entered on the keyboard
4= fixed 4 decimal places (x.0000)
3= fixed 3 decimal places (x.000)
2= fixed 2 decimal places (x.00)
0= fixed 0 decimal places (x)
add 2= (add mode*,fixed 2 places) (\$.00)
Note* "ad mode" automatically enters the decimal place when entering the number on the keyboard. If you enter "123", the displayed ammount will be "1.23". If you enter "1", the display will read ".01". This is a useful setting when adding a list of numbers in a dollars/cents format, however, be careful, if entering a whole dollar ammount "three dollars" be sure to enter the decimal point, or enter the number as "300". If you don't, the result will be ".03", instead of the 3 dollars you intended.

May 20, 2011 | Royal 29307U Calculator

3 Answers

### How to round the fig. in Excel 2007 E.g. 12350*32.75% = 4044.625 I want it to be rounded to nearer rupee. If the decimal is lesser than 50, rounded fig. should be lower Rupee if the decimal is more than 50...

The function is called ROUND. It has 2 arguments, (1) the original number and (2) the number of decimal digits. Here is the Excel's help: ROUND(number,num_digits) The number you want to round. None. num_digits The number of digits to which you want to round number. If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places. If num_digits is 0, then number is rounded to the nearest integer. If num_digits is less than 0, then number is rounded to the left of the decimal point.
So for your case use this in a cell "=ROUND(12350*32.75%, 0)" without quotes, where I assume one or both numbers will come from other cells. -Ken

Aug 29, 2009 | Microsoft Office Excel 2007

1 Answer

### Excel 07 truncuating problem

You need to use the ROUND function.
E.g. type: =ROUND(A1,2)*A2

Assuming the 2.131576 is in cell A1 and 1000 is in A2.
The round function round the value to 2 decimals (in this case because I specified 2 as the second argument).

May 06, 2009 | Keystone Excel 2007 Essentials for PC...

1 Answer

### Excel

Step1. Start Microsoft Excel and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. \$('.Article .Steps .Image').each(function(i,e){ e = \$(e); e.find('img').error(function(){ \$(this).unbind(); e.remove(); }); });
Tips & Warnings
• Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
• Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

### I lost my decimal point

You need to be in add mode, and have 2 decimal places selected for the result.
To change to add mode, make sure the 'K . A' switch is in the 'A' position. To get 2 decimal places in the answer, move the selector in the 'F 6 3 2 1 0' switch to the '2' position.

You can see the above described at

this Sharp.com page which shows the users manual. The manual shows examples.

Mar 19, 2008 | Sharp EL-1197P Calculator

1 Answer

### Land measuring

Just follow the steps....
1. Type "Enter Land in Gundas" in A1
2. Type "Equivalent Land in Acres" A2
3. Type "=B1/40"
4. Now type the number of gundas in B1 example 100
5. you will automatically get 2.5 in B2
Now you need only two decimals tighy?
1. Select B2 Cell
2. Right Click and goto Format Cell
3. Goto Number
4. Under Number select Number Catogory
5. and then select 2 decimals
Thats all

Jan 31, 2008 | Computers & Internet

## Open Questions:

#### Related Topics:

139 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

18425 Answers

Level 3 Expert

2678 Answers

Level 3 Expert

14162 Answers

Loading...