Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone Knows How do i change Data Type of a dimension in the GUI?
When I export the table to Excel and it comes out as Text and i need it to be Number or Integer.
I tried Num / Num# and no success.
Thanks Onn Bar
Can you share your sample data file?
You can't change the data type, only the formatting. But exporting to excel doesn't also export the formatting. You can either use a macro to export to excel and change the formatting. Or you can manually change the formatting in excel.
Hi,
can you post sample data which you want to convert in number.
If you set the data type under Settings- Document Properties- Number and make sure the field you want to change is set to the format you want it in. Exporting to excel seems to pick up this formatting.