This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi Community, I have a table in a worksheet and when I add a row before to fill any value in the row, on of the column value is set automatically with 0 (cero) depite the whole column is set as text, but this is not the issue, the issue is I get error "Inconsistent calculated column formula" in that cell everytime. This column hast text format plus data validation = to a name range. The dropdown list is working fine showing the right value. Any clue why this is happening? Many thanks.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Maria,
To better address your concern, kindly refer to the support link below:
let us know if you need further help.
Best regards.