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