Excel: Decimal Placement Appearance

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
John EllisAsked:
Who is Participating?
 
John EllisConnect With a Mentor Author 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)

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

range("A2510") = range("A2510").Text
0
 
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
Next

Application.ScreenUpdating = True
Application.EnableEvents = True

End Sub

Open in new window

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
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.
0
 
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
0
 
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
0
 
John EllisAuthor Commented:
My colleague gave me the correct response.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.