multiplying two cell locations

[estragon]

When multiplying two cell locations which contain decimal values I get #VALUE error displayed.
Multiplying whole numbers is ok
Formatting the cells for 'number', 'general' or 'currency' doesn't affect the result.
Help!!

[XOR LX]

Hi,

Can you post an example of this error in a workbook?

Regards

[estragon]

Hi,

Can you post an example of this error in a workbook?

Regards

Hope this works. Haven't done any of this forum business before.

[L-Drr]

Your values are no values, because the decimal separator is wrong. I don't know if you're using a point or a comma, but try to use the other one (if you use the NumPad you always have the right one).

[estragon]

Thanks for that. That fixes it. Changed entries decimal point separator to comma and value error disappears. That's all ok but I want to use decimal points, not commas. This is a new problem for me. Been using point as separator for years, why the sudden change i an old existing spreadsheet? Any idea?

[L-Drr]

Lol don't know why it suddenly changed, but I think your solution is here:
http://blogmines.com/blog/2010/03/11...in-excel-2010/

[estragon]

Gotcha. Feel a bit silly now!! Thanks a lot

[L-Drr]

You're welcome!
Please mark the thread as solved (above your first thread post under Thread Tools) and consider adding Reputation (lower left cvorner of a post)