Convert 10 Decimal Places to 2

S

Sheri-NWC

I need to convert a column of figures such as 136.573297808087 to 136.57
preferably automatically.

This is not just for display purposes, but the content of each cell must
only contain 2 decimal places. It is being used as a database for a Word
merge. When the column is merged into the word document, it displays all 12
decimal places, but I only want it to display 2.

Any suggestions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Using Excel as data for mail merge... 1
format issues with decimal places 1
Reducing decimal places 4
How do I 'SUM' a column corrected to 2 decimal places from 3 2
Data Validation - 2 decimal places 4
How to retain decimal zeroes? 5
Automaticallychanging the number of decimal places displayed 5

Top