I have a spreadsheet that is output from an Access form.

H7 (General format) holds =SUM(H2:H5). This is right-justified.
Autocalculation is on
H2 to H5 (General format) hold what appears to be numbers and is
left-justified.
H7=0
If I reformat H2 to H5 as number with 2 decimals, the appearance doesn't
change and H7 remains at zero.
If I double click on eg H3, then click elsewhere, H7=H3.

So it appears that the numbers in H2 to H5 are actually text.

This all used to work, but some changes have been made to the database and
now we have this problem. If I can't find the root cause (ie why Access it
outputting in this way), how can I programmatically change the values in
column H into numbers?

Ian