Wow, a lot more answers than I expected. From what I've gleaned from your answers it's like crossrulz says it's how Excel is reading it and there's nothing to be done in LV. The reason I asked in the first place was the powers that be didn't like the way it looked when he read the data. I'll just tell him he'll has to go through the excruciating process of clicking his mouse a couple times to change the formatting. He'll live.
Thanks all for the input, it never ceases to amaze me how willing people are to help out on this forum.
