Forum Discussion
Receiving "VALUE" errors in data sheet while others in same file dont see this
Hi, A friend sent me a Excel file in which I can add data which is translated into useful information for analysis on later sheets of that same excel file. After filling in the data, I get to see "V...
Floris1988 I suspect that your problem lies in the fact that the data had the comma as the decimal separator where your settings expect a period. Excel sees them as text and trying to calculate with plain text produces the #VALUE! error. Widen the columns with the ##### signs, and you'll probable see #VALUE! there as well. The number that did come across to your summary sheet was "1", being the only number without a decimal in the input sheet.