What happens if you click in the affected cell, press F2 then press Enter?
Does it sum then?

I suspect that the numbers are stored as Text even though they are formatted
as Number.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Mark" wrote in message
...
I am using Excel 97. I have created a userform which
calculates mileage travelled from A to B. If I type the
values directly into the worksheet the cell which SUMS
add them up. But if I use the userform when the values
are tranposed they don't SUM. I have tried using the
formats of both #.## & £#,##0.00 when the values are
transposed from the userform to the worksheet, but they
don't SUM. I also made sure the format values in the
cells on the worksheet are formatted to currency.

Any suggestions/solutions would be very appreciated.

Thanks

Mark