Summing Currency

[TOM M]

Hello,

I have 10 cells formatted as currency displayed to 2 decimal places. These cells are a % of a separate total figure and the actual value is greater than 2 decimal places.

I want a sum of the displayed values, however when i autosum, excel sums the true values and displays that at 2 decimal places

Any help is appreciated

Thanks Tom

 

[VoG]

Try

=SUM(ROUND(A1:A10,2))

confirmed with CTRL + Shift + Enter, not just Enter.

 

[scottylad2]

Go to the format menu, then change currency to number and have it display as many digits afer the decimal as you need then format as currency again, it will display all digits that way

 

[scottylad2]

misread, thought you wanted to diplsy everything

 

[TOM M]

Worked Perfectly VoG, thanks