Home 
Search 
Today's Posts 
#1




eliminating decimal places
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? 
#2




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? 
#3




eliminating decimal places
On Mar 19, 3:02*pm, 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? If you don't wish to change the whole workbook, then perhaps you could try using =round([range],2). If you wish to convert just one sheet, then use this function in all of the equivalent cells in a new sheet, i.e. try making NewSheet!A1 =round(OldSheet!A1,2) and so on. If your rounding system requires a different direction, then perhaps try =roundup(...,...) or =rounddown(...,...). 
#4




eliminating decimal places
On Mar 21, 9:34*am, "
wrote: On Mar 19, 3:02*pm, 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? If you don't wish to change the whole workbook, then perhaps you could try using =round([range],2). If you wish to convert just one sheet, then use this function in all of the equivalent cells in a new sheet, i.e. try making NewSheet!A1 =round(OldSheet!A1,2) and so on. If your rounding system requires a different direction, then perhaps try =roundup(...,...) or =rounddown(...,...). Sorry  line 8 SHOULD SAY "try using =round(range,2)". 
#5




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' 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Decimal Places  Excel Discussion (Misc queries)  
Subtracting two 2decimal place numbers gives result 13decimal places?  Excel Worksheet Functions  
Max decimal places  Excel Discussion (Misc queries)  
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT.  Excel Discussion (Misc queries)  
add 2 decimal places  Excel Discussion (Misc queries) 