Hi Colin,
Formatting numbers to 2 decimal places doesn't truncate the actual data,
only the displayed data. All decimal places (up to 16, I think) are
remembered by XL, and always used in calculations.
Regards - Dave.

"Colin" wrote:

Is there any way that I can "Autosum" a column which has numbers formatted to
2 decimal places - were the "Autosum" adds the numbers as shown in the cell
(not the numbers with full decimals). e.g. 1.2345 will show as 1.23 but when
added includes the,0045 and shows an answer which does not add up according
to the info displayed?