Data is neither text nor number

Format the cells to numbers as required and then delete the ‘invisible’ characters at the front of each of the individual numbers. There may be two or three of them.

It does work with the copy and paste method in excel anyway.

1 Like