This discussion is archived
1 Reply Latest reply: Oct 15, 2012 3:52 AM by AlexAnd RSS

Xml Rtf has value as Regular Text,but in Excel it is considering as Number

865777 Newbie
Currently Being Moderated
Hi All,

In XML Rtf ,for an Item,the value in Text form Field is set as 'Regular Text',and we are generating the output in excel.
In Excel this item value is considering as number.

For Eg : 0120190 is the actual Item,but in excel it is displaying as 120190,'0' is missing.

Needed the output to print as it is 0120190,Please let us know how to accomplish this.

Thanks
Sreekanth

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points