Good day,

I have read with great interest the various posts on the common #Name? error
and one good solution is to select a column and then select DataText to
columnsFinish to fix the error.

But, my question is as follows: why does this happen?

When I select a cell, it is clearly formatted as "number" however, Excel
seems to see it as text, hence the error.

Why is this?

Thanks for your help, it is always greatly appreciated.

Helene