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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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
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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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)

John
0

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