We have a strange bug and it is unfortunately impossible to search for something like this because there are so many other unrelated search results. So I have to try here.
One of my co-workers has the strange problem with Excel that if you enter -0.02 or something like -0.51 it ends with #Value!
Even if we try to change the cell or column from "General" to "Everything else", the value "#VALUE!" Specified.
When I check the value, it is = 0.02 instead of -0.02. The rest of them. When I check the same spreadsheet in Excel 2010, I see "= _FV (0;" 02 ")".
Entering -0.02 indicates that Micrsofot Excel found an error in the entered formula.
Does anyone have any idea why this might be?