Select one column and DataText to ColumnsFinish

Works most of the time.

OR.....maybe numbers are text.

Format all to General, copy an empty cell.

Select all and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP


On Mon, 14 Jan 2008 13:53:03 -0800, Thuizt
wrote:

We encounter the same issue.
By selected a wrong cell and pressing F2 (edit) followed by just pressing
the enter key to confirm. The formula accepts normally.
Anyone recognizing this behaviour or better having a solution for it.

Thanks