Thanks for the reply.. ultimately this is what i did, i divided the number by 100 before i copy it to excel but
Is there a reason why NumberFormatID=9 multiplys the value with 100?
and also can you give a rough ETA on support for graphs and charts?
Your efforts are greatly appreciated
Thanks & Regards