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

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

It doesn't SUM !

How do you make the stored values into numbers, please?

Mark


-----Original Message-----
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


.

Sorry - it should have summed. I'm at a loss.

What happens if you copy a number from another workbook overtop of that
cell? Does it sum now?



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


"Mark" wrote in message
...
It doesn't SUM !

How do you make the stored values into numbers, please?

Mark


-----Original Message-----
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


.