[QUOTE=vinurules;90286]
I faced great trouble while taking report of reference in excel ,get converts to some other value as output comes.
Ex [COLOR=#333333]=9653/96542 get converts to [/COLOR][TABLE="width: 87"]
[TR]
[TD="class: xl63, width: 87, align: right"]0.09998757[/TD]
[/TR]
[/TABLE]
If the cell formatting in Excel is "General" then Excel assumes it as formula and calculates division. Change cell formatting by Right click | Format | Text to avoid this from happening.
You can also address this while doing text to columns of the *.txt output. In video link the format option comes at the end @1:32
Change the formatting for the Dbref column to text.
[QUOTE=vinurules;90286]
I faced great trouble while taking report of reference in excel ,get converts to some other value as output comes.
Ex [COLOR=#333333]=9653/96542 get converts to [/COLOR][TABLE="width: 87"]
[TR]
[TD="class: xl63, width: 87, align: right"]0.09998757[/TD]
[/TR]
[/TABLE]
If the cell formatting in Excel is "General" then Excel assumes it as formula and calculates division. Change cell formatting by Right click | Format | Text to avoid this from happening.
You can also address this while doing text to columns of the *.txt output. In video link the format option comes at the end @1:32
Change the formatting for the Dbref column to text.
