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

Mail Merge - displaying a conditional number of decimals 5
Converting decimal degrees to degrees, minutes & seconds 2
How to retain decimal zeroes? 5
format issues with decimal places 1
Data Validation - 2 decimal places 4
How do I 'SUM' a column corrected to 2 decimal places from 3 2
decimal places 2
Fixed decimal places in Excel 4

Top