Hi Ian,

You can programmatically mimic the manual solution:

Format an empty cell as number (just to be sure)
EditCopy
Select your "numbers"
EditPaste special, check Add

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Ian" wrote in message ...
|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
|
|