topic Re: Convert zero to number and right allign in QlikView https://community.qlik.com/t5/QlikView/Convert-zero-to-number-and-right-allign/m-p/96268#M761985 <HTML><HEAD></HEAD><BODY><P>I Got it. Used replace()</P></BODY></HTML> Thu, 02 Aug 2018 00:42:43 GMT viveksingh 2018-08-02T00:42:43Z Convert zero to number and right allign https://community.qlik.com/t5/QlikView/Convert-zero-to-number-and-right-allign/m-p/96267#M761984 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I want to replace null nd missing values with zero nd convert it into number. </P><P>I Have changed this in presentation tab, it is working fine in Qlikvie. But when I export ti excel, zero is alligning to left as text.</P><P>I Want it to be as number and right alligned. </P><P>Actually, the field doesnot have any zero values. But when I count the field on dates for few of the dates it doesnot have any value. So I’m replacing the mussing and null with zero. Now I want the zero value to be right alligned as nunber when exported to excel. </P><P>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-zero-to-number-and-right-allign/m-p/96267#M761984 viveksingh 2020-11-25T16:16:04Z Re: Convert zero to number and right allign https://community.qlik.com/t5/QlikView/Convert-zero-to-number-and-right-allign/m-p/96268#M761985 <HTML><HEAD></HEAD><BODY><P>I Got it. Used replace()</P></BODY></HTML> Thu, 02 Aug 2018 00:42:43 GMT https://community.qlik.com/t5/QlikView/Convert-zero-to-number-and-right-allign/m-p/96268#M761985 viveksingh 2018-08-02T00:42:43Z