Thanks Bjorn,

it seems to work fine. However, I found a simpler way that suits my needs.

I added an extra column to the right of my formula, and did a Copy-Paste special (formula). I then added a quote sign ( ' ) in front of the formula and dragged the formula down. this will turn the cell into a "text" field, thus displaying the formula.