when i try to create a chart I get a blank chart.
I have selected all the numbers and set format as a general number but it does not make any difference.
Then I noticed (even after formatting above) that in the input bar each number has a ’ before it.
The numbers were from an export file.
Can anyone advise how to format all the numbers to get rid of the ’ in each cell.