Null value syntax of export XML

[michael]

Dear all,

I use excel 2003 to export a excel file into xml file. For those blank
cells in the excel file, I input a ' so that excel can recognize it as a null
value when exporting to xml. After exporting, the syntax of null value in
the xml file will look liked
<remark/>
However, I expect the syntax of null value will look liked
<remark></remark>
Everytime I will use Notepad to modify the syntax. May I ask whether there
is any method to modify the xml output syntax?

Thanks.

Regards,
Michael