It looks like the leading ’ [single quote] character may be causing formatting issues.
How do I get rid of it?
TIA
It looks like the leading ’ [single quote] character may be causing formatting issues.
How do I get rid of it?
TIA
Hello
the leading single quote is an indication that
Select the column showing textual data (numbers) and use Data -> Text to Columns
to convert to numbers (no selections/settings required - just click OK
)
Hope that helps.
If the answer helped to solve your problem, please click the check mark () next to the answer.
Thanks!!! I actually did have to select the whole column to effect the change.