View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sheri-NWC Sheri-NWC is offline
external usenet poster
 
Posts: 1
Default 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?