When you import numbers from other systems they sometimes come in as text and are left aligned.
There are a couple of ways to fix them and they can both be done in less than a minute.
Let’s see how to convert text numbers into real numbers, real fast.
Here is another way to convert all of the number forms you showed (apostrophe numbers, text number and text formula calculations) with a single two-step method… select the entire column, change the cell format to General (you can do this by clicking the General on the drop down in the Number panel on the Home tab), then bring up the Text To Columns dialog box (Data tab, Data Tools panel) and click the Finish button as soon as the dialog box appears. All your values should now be real numbers.
Cool – thanks for that Rick.
I might do a separate quick video showing the technique.
Seems Text to Columns isn’t redundant just yet.