0

I am trying to display data which is in fraction .

Example : I want to display 1/8 ,5/32 in Excel.

The XML file has 1/8 ,5/32 as the data but when I publish it in Excel using BI publisher the data is converted to dates Jan-8 . How can I avoid this issue?

Adriano
  • 3,788
  • 5
  • 32
  • 53
NoviceCode
  • 3
  • 2
  • i tried the suggestion on the below link , however it did not work : https://stackoverflow.com/questions/18335486/oracle-bi-publisher-how-to-format-numbers-as-text-so-that-leading-zeroes-dont – NoviceCode Nov 02 '18 at 22:52
  • 1
    If you prepend the data with a single quote that will force display as text – Tim Williams Nov 02 '18 at 23:12

0 Answers0