View Single Post
  #5   Report Post  
Old October 10th 14, 11:29 AM posted to microsoft.public.excel.newusers
[email protected] is offline
external usenet poster
First recorded activity by ExcelBanter: Oct 2014
Posts: 1
Default eliminating decimal places

On Friday, March 19, 2010 3:02:01 PM UTC, 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?

What i did was
- us the round function get the required rounding.
- copy the new figures
- paste new figures as 'values'