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 thecell.

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(...,...).