Hi All

I am new bee to excel and Xml.

In my Sheet1 A12 I have a text

Date of board meeting when final accounts were approved

In the Sheet 1 B12 i have entered a data

2011-12-07

I have to convert into xml. The output should like in this format


<in-ca:DateOfBoardMeetingWhenFinalAccountsWereApproved >2011-12-07</in-

ca:DateOfBoardMeetingWhenFinalAccountsWereApproved>


How can i do it. I dont know macros.

kindly give me any ideas.


Thanks in advance