View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default eliminating decimal places

Set Calculation options to "precision as displayed"

Not this a workbook setting and will affect all numbers.

There is no returning after numbers have changed.


Gord Dibben MS Excel MVP

On Fri, 19 Mar 2010 08:02:01 -0700, Catherine wrote:

On an excel spreadsheet downloaded from an external source there are eight
decimal places in the numbers. If I format to two decimals it displays the
number with two decimals but still keeps the eight decimals when in the cell.
This makes it difficult to upload the info into our ERP system as that system
rounds differently. How can I permanently get rid of the extra decimals?