Click in the cell and press enter (but many times)

When working with data, especially imported data, you may find that simply by clicking in a cell and then pushing enter, the ‘text’ will convert to numbers (it suddenly goes from left aligned to right aligned). If you have tried other methods that haven’t worked then below are some methods that mimic this process but all in one go. Effectively what we want is Excel to go into a cell and then come out to go to another cell (much like you do when you click in a cell and push enter).