Excel Remove Decimal Places | Edureka Community

168035/excel-remove-decimal-places

• Home
• Community
• Categories
• Database
• Excel Remove Decimal Places

Excel Remove Decimal Places 0 votes

I have an excel formula that is producing a lot of decimal places and I cannot reduce them using the format cell -> numbers -> decimal places options. Here is the formula.

Cell named V01_MIN V01_MIN =MIN(6:6) Has a value of 2

Cell named V01_MAX V01_MAX =MAX(6:6) Has a value of 1800

Cell named V01_A V01_A =1-V01_MIN*V01_B Has a value of 0.889877642

Cell named V01_B V01_B =99/(V01_MAX-V01_MIN) Has a value of 0.055061179

X6=723 X7=V01_A+V01_B*X6 (value of 40.69911012) X8=1 X9=X7*X8 (value of 40.69911012) X10=1 X11=X9*X10 (value of 40.69911012) X13==CONCATENATE(X12,", ",X11)

The final results of X13 are:

V01, 1162, 40.6991101223582

I want them to be:

V01, 1162, 40.7

I'm trying to figure out how to make this happen. I've already tried changing the cell formatting on all of these cells (including the final cell) to one decimal palce and that didn't work.

• excelexcel-formula

Mar 23, 2022 in Database by Edureka • 13,690 points • 30,118 views answer comment

• flag

Your comment on this question:

Your name to display (optional):

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Add comment Cancel

1 answer to this question.

Your answer

Your name to display (optional):

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

Add answer Cancel

0 votes

1) E2 is the cell from which you will subtract decimal digits in the formula =INT(E2). 2) After a decimal, the INT function can keep particular digit positions. You can use the formula =INT(E2*10)/10 to delete all digits following the decimal save the first one.

In a blank cell besides the value you will remove digits after decimal, enter the formula =INT(E2), and the drag the Fill Handle to the range you need.

answered Mar 24, 2022 by gaurav • 23,580 points comment

• flag
• ask related question

Your comment on this answer:

Your name to display (optional):

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Add comment Cancel

Related Questions In Database

0 votes 1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15, 2022 in Database by gaurav • 23,580 points • 3,362 views

• excel
• replace
• excel-formula
• concatenation

0 votes 1 answer

Remove time from date field in Excel formula

Use the Find And Replace function to ...READ MORE

answered Mar 30, 2022 in Database by gaurav • 23,580 points • 1,556 views

• excelexcel-formulaformula

0 votes 1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

answered Mar 30, 2022 in Database by gaurav • 23,580 points • 1,459 views

• excel-formulaexcel-2010

0 votes 0 answers

Rounding off to two decimal places in SQL

Minutes must be converted to hours and ...READ MORE

Aug 9, 2022 in Database by Kithuzzz • 38,000 points • 2,068 views

• sql
• rounding

0 votes 1 answer

Excel - Split cell with a delimiter and if delimiter not found get complete cell value to another cell

Select the row or column that you ...READ MORE

answered Feb 23, 2022 in Database by gaurav • 23,580 points • 1,419 views

• excelexcel-formula

0 votes 1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15, 2022 in Database by gaurav • 23,580 points • 1,261 views

• excelexcel-formula

0 votes 1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

That's a great question, and it's a ...READ MORE

answered Mar 24, 2022 in Database by gaurav • 23,580 points • 3,389 views

• excelexcel-formula

0 votes 1 answer

EXCEL: How to automatically add serial number in Excel Table using formula that is immune to filtering / sorting?

These techniques can add a running column ...READ MORE

answered Mar 24, 2022 in Database by gaurav • 23,580 points • 2,886 views

• excelexcel-formula

0 votes 1 answer

Excel Remove Decimal Places

INT function: Remove digits after decimal in ...READ MORE

answered Apr 11, 2022 in Database by gaurav • 23,580 points • 1,294 views

• excelexcel-formula

0 votes 1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15, 2022 in Database by gaurav • 23,580 points • 2,566 views

• excelexcel-formula

Recent in Career Counselling

• testing question for logout case, please dont approve it Feb 11
• I have experience in RPA can i enroll for prompt engineering and get job Aug 6, 2024
• Gap in experience Nov 18, 2023
• What is the best course for a Civil Engineer who is seeking to switch to IT? Apr 25, 2023
• What are the roles and responsibilities of Research and Development Manager Apr 14, 2023

• All categories
• Generative AI (1,454)
• Power BI (1,316)
• DevOps & Agile (4,138)
• Data Science (100)
• ChatGPT (30)
• Cyber Security & Ethical Hacking (1,057)
• Data Analytics (1,266)
• Cloud Computing (4,053)
• Machine Learning (337)
• PMP (1,069)
• Python (3,489)
• SalesForce (201)
• Selenium (1,624)
• Software Testing (58)
• Tableau (608)
• Web Development (3,972)
• UI UX Design (24)
• Java (1,358)
• Azure (157)
• Database (858)
• Big Data Hadoop (1,907)
• Blockchain (1,673)
• Digital Marketing (121)
• C# (141)
• C++ (272)
• IoT (Internet of Things) (390)
• Kotlin (8)
• Linux Administration (389)
• MicroStrategy (7)
• Mobile Development (395)
• Others (2,387)
• RPA (653)
• Talend (73)
• TypeSript (124)
• Apache Kafka (84)
• Apache Spark (596)
• Career Counselling (1,091)
• Events & Trending Topics (28)
• Ask us Anything! (71)

×

Join the world's most active Tech Community!

Welcome back to the World's most active Tech Community!

Sign up with Gmail Sign up with Facebook

OR

Please provide a valid input Password must have

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

SIGN UP Already have an Edureka Account? Login Please enter a valid emailid Forgot Password? LOGIN Don’t have edureka account? Sign Up resend ? Password must have

At least 1 upper-case and 1 lower-case letter

Minimum 8 characters and Maximum 50 characters

reset password Don’t have edureka account? Sign Up reset password Don’t have edureka account? Sign Up Send Code Don’t have edureka account? Sign Up

Subscribe to our Newsletter, and get personalized recommendations.

Sign up with Google Signup with Facebook

Already have an account? Sign in.

× REGISTER FOR FREE WEBINAR X Years of Experience* Student 0-2 Years 2-5 Years 5-10 Years 10+ Years REGISTER NOW Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP "PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.