Ok, I'm helping someone out with a mailmerge and there's something I can't figure out.

I've actually done a lot of mailmerges (on office 2000) but this one is odd.

Package: Word/Excel 2003

Problem:

This is the data:

http://img352.imageshack.us/img352/9162/exceloy0.jpg

This is what the document looks like, with the document merged to the data highlighted in blue above.

http://img155.imageshack.us/img155/921/mergednc7.jpg

As you see from the first picture, the overtime rate from the data is "n/a", but when it's merged to the document it comes through wrong.
Now I thought at first it might be Word not reading the text correctly (when it's expecting numbers), but if you look at the Shift Premium that has come through correctly - as well as the 2 boxes below it.

For completeness, here is the field codes used:

http://img530.imageshack.us/img530/947/unmergedbe4.jpg

Now as you can see, I have put field codes in that was copied directly from an MS website, to change the data - putting a pound sign in, only displaying a certain number of figures and putting 2 decimal points in.
I have tried removing those codes to see if that makes a difference - if I do that, the field reads "0" instead.

And just to confirm, if I merge the document with a line further up that actually has a number as the Overtime rate, it comes through correctly.

All of the cells are formatted as text, but I have tried to format it as currency, general, number and none of that makes a difference.