Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to just enter a number for the amount of inventory we have. I do not want decimal places and I want to type in the number without it rounding.

For example when I type in 6, it reads as 0.06 and rounds to 0. I just want to see 6 in the cell and I want it to be a number.

share|improve this question

2 Answers

up vote 1 down vote

The cell you're typing in is probably formatted as a percentage, with one decimal place. Right-click the cell, click "Format Cells", and open the Number tab. Select the "General" number type.

Note that if the number is solely for human reading, and you won't ever need to do calculations on it, the "Text" format is better, as it will accept the input exactly as written.

share|improve this answer
It is formatted as number with no decimal place. I can't use text as the cell will be part of a formula – Jeanne Hesselberg Dec 7 '12 at 14:25
2  
That's fine then. The "General" type should be sufficient for your needs. – Jonathan Garber Dec 7 '12 at 14:32
but when I type in 6, It registers 0.06 and rounds to 0 – Jeanne Hesselberg Dec 7 '12 at 15:11
Thanks for the edit Jonathan, you obviously had the right Excel version at hand ;-) – Jan Doggen Dec 8 '12 at 18:41
up vote 0 down vote

If you enter 6 and it appears as 0.06 you have Excel set up to automatically add decimal places.

Change that like this depending on your Excel version:

Excel 2010 - Click on File Menu at top left - select "Excel Options" then go to "Advanced" and under "Editing Options" untick the "automatically insert a decimal point" option.

Excel 2007 - Click on Office button at top left - select "Excel Options" then go to "Advanced" and under "Editing Options" untick the "automatically insert a decimal point" option.

In Excel 2003 and earlier versions you can access this option through Tools > Options > Edit > untick "Fixed decimal Places"

Once you have done that make sure your cells are formatted to General or number (zero decimal places) and when you enter 6 you will see just 6.....

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.