Too many decimal points with dollar values

[murraythek]

hello,

I'm using the "&A1&" formula to reference dollar value totals. Cell A1 is formatted to 2 decimal points, but the referenced cell destination is adding more than 2 decimal places!

thanks

 

[Joe4]

Try:

& TEXT(A1,"0.00") &

 

[joeu2004]

I think it would be prudent to round the calculation in A1 itself, to wit: =expression becomes =ROUND(expression,2).

Even so, Joe4'2 use of TEXT is still prudent because it forces rounded numbers of the form 1.2 to be displayed as 1.20 in the text formula.