View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jon jon is offline
external usenet poster
 
Posts: 13
Default Peremanently removing decimal places

Hi,
I have a price list that displays all prices to 2 decimal places, but some
prices are actually to 8 or 9.

I have copied all the fields and done a Paste Special Values, which has
removed the calculations, but I now need to change all the fields to
actually be 2 decimal places, not just to display 2 decimal places.

Is there a way of doing this ?

Thanks

Jon