Good Day,

I have a report where I need to export the information to excel.

My data can look like this:

Number Status   OpenDate  CloseDate           Closedby       Model#
123       Closed   01/01/11   01/02/11             tjones           JKKJHH
124       Closed   01/01/11   01/03/11             tjimes            KYHSNF
125       Open     02/01/11                                                    THHSSE
126       Closed   02/01/11   01/04/11             jdoe              JJSDJSM

When I export the data to excel, it looks like this:

Number Status   OpenDate  CloseDate           Closedby       Model#
123       Closed   01/01/11   01/02/11             tjones           JKKJHH
124       Closed   01/01/11   01/03/11             tjimes            KYHSNF
125       Open     02/01/11    THHSSE
126       Closed   02/01/11   01/04/11             jdoe              JJSDJSM

Whenever I have a blank CloseDate or Closedby, the information from the Model# field moves over to the CloseDate field.

I have aligned my columns. I have set up the fields so they are all the same size. I have the column headers in my report header. The data lines up with the ruler. I have aligned the tops of the rows...nothing seems to work.

Any idea how I can trick Excel into thinking the fields are populated without actually putting data into that field?

Any help would be greatly appreciated!