I have set up a worksheet where I'm importing data with the "find column" function. Everything is working except one thing. When I'm importing data from a position with no information I want the cell to be blank. This is the case for 90 % of the missing cells but for some locations excel writes 0 instead. This is giving me great problems when I'm ploting the data later on.

I have seen that if you never have used the blank cell it will stay blank when imported, but If I write a number in it and erase it it will be a 0. I have tried the format painter but it doesnt help.