export to excel with number format
Posted: Mon Sep 29, 2014 8:23 am
hi, I want to format my sticell as number , consider my number is 123456.123456
if I use number and set decimal number count and ... I would have some extra zeros at the end if the number would have less decimals like 123.12 or I lose a part of my number.
and if I use custome format like "###,###.,#########" every thing is ok but when I export it to excel it becomes string.
Can I export "number" to excel without any changes of my number ?
if I use number and set decimal number count and ... I would have some extra zeros at the end if the number would have less decimals like 123.12 or I lose a part of my number.
and if I use custome format like "###,###.,#########" every thing is ok but when I export it to excel it becomes string.
Can I export "number" to excel without any changes of my number ?