Convert 10 Decimal Places to 2
 

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?

Convert 10 Decimal Places to 2
 

trya helper column wtih this formula copied down as needed:
=ROUND(A2,2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sheri-NWC" wrote:

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?

Convert 10 Decimal Places to 2
 

THANK YOU!!!!!! You have just me a HUGE amount of re-entry.

Sheri

"Luke M" wrote:

trya helper column wtih this formula copied down as needed:
=ROUND(A2,2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sheri-NWC" wrote:

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?

Convert 10 Decimal Places to 2
 

You're welcome, and thanks for the feedback. =)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sheri-NWC" wrote:

THANK YOU!!!!!! You have just me a HUGE amount of re-entry.

Sheri

"Luke M" wrote:

trya helper column wtih this formula copied down as needed:
=ROUND(A2,2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sheri-NWC" wrote:

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?