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.
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.