New columns are always added to the right edge of the dataset. Simply click and drag a column by its header to move it. Also, remember to check that it has the correct format applied to it by clicking ...

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...