We help IT Professionals succeed at work.
Get Started

Excel: Decimal Placement Appearance

83 Views
Last Modified: 2017-11-04
Hello:

I need for the numbers in each column of the attached Excel spreadsheet to "be" just as they appear.  

For example, in cell A2510, I need for the number to be just as it appears.  It needs to be 15440.92243.  It should not be 15440.9224333333, as Excel is showing it as at the top of the application.

What do I need to do, in order to make this happen?

Thank you!

John

Experts-Exchange-Decimal-Format.xlsx
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE