Skip to Content
Former Member
Jun 27, 2015 at 02:46 PM

How to convert datatypes


Hi All,

I have a column which is number datatype (dimension), this column containing zeros. I suppress zeros with this formula =if [object]=0 then " " else [object], now this column has become string datatype. How can I change this column back to number datatype column, after applying the above forumla.

Because I want to apply number format on this column.

Thanks and regards,