answersLogoWhite

0


Best Answer

Your question is a little vague, but it sounds like a display issue. Specifically, it sounds like you have your number display set to show zero digits past the decimal point. Simply select the cell you're interested in reformatting, click on Format/Cells/Number/Percentage and make sure you have it set to display at least one (if not more) decimal digits.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you Calculating percentage in excel that is less than 1?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is greater than and less than in Excel?

The > is used for greater than. The < is used for less than.


What is excel arithemetic operator less then?

The less than operator is the < symbol.


What are the standard operators in Excel?

The logical operators in Excel are as follows. < is less than, > is greater than, = is equals. <= is less than or equals and >= is greater than or equals. Not equal to is written as <>.


How do you add less than symbol in Excel?

The less than symbol is and you can add the symbol in the input line when typing a formula.


What format is used to display non-currency numbers?

There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.There are a number of formats in Excel that can be used other than currency and accounting, like percentage, fraction, general, scientific and number. Date and Time formats can also be applied to numbers.


Is 0.0053 less than 1 percent?

It is less, in percentage terms it is 0.53%


What percentage of your body is food?

less than 1%


What is the percentage of earth volume?

Less than 1%.


What percentage of blacks have an MBA?

Less than .5%


What percentage of goods are recycled?

Less than 1%


What percentage of people have a 401k?

less than half


How much does Oprah pay in taxes?

Much less than you did last year percentage....check the tax laws. She makes 222,000,000 per year, but pays less percentage than you do. Yes American workers, less than you.