Excel: Decimal Placement Appearance


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 EllisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
You would need to do something like this for each cell.

range("A2510") = range("A2510").Text
Martin LissOlder than dirtCommented:
Here's a macro that will do that.
Sub AlterValue()
Dim cel As Range

Application.ScreenUpdating = False
Application.EnableEvents = False

For Each cel In ActiveSheet.UsedRange.Cells
    cel = cel.Text

Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub

Open in new window

John EllisAuthor Commented:
I get an error with the use of that formula.  Can you please show me how to place it in Excel?

I'd prefer not to use a macro.
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

John EllisAuthor Commented:
Also. I just now tried to make the cells to be text.  The results were not what I wanted.  Doing so added extra decimal placement.

John EllisAuthor Commented:
Actually, a colleague of mine gave me the answer that I needed.

The answer is to use the "ROUND" function, as follows:

=ROUND(15440.9224333333, 5)


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob HensonFinance AnalystCommented:
There is an option in Excel that will force calculations to use the precision as displayed.

So use the normal formatting tools to get the number of decimal places required and then use Excel options to set this option:
Precision setting
John EllisAuthor Commented:
My colleague gave me the correct response.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.